Database MCQ’s

Database MCQ’s

1. Table with similar records is

A. Record

B. Field

C. File

D. None

Answer - Click Here:

2. SQL is a

A. Software

B. Structured language

C. Unstructured language

D. Object oriented language

Answer - Click Here:

3. Retrival  and storage of data is

A. Managing output

B. Data manipulation

C. Data capturing

D. All of these

Answer - Click Here:

4. Process of merging relations is …

A. View relations

B. View data models

C. View integration

D. None of these

Answer - Click Here:

5. In  E-R diagram, an oval is for

A. Relationship

B. Entity

C. Attribute

D. Process

Answer - Click Here:

6. Example of one-to-many relationship in E-R diagram

A. Father-son

B. Teacher-student

C. Country-capital

D. Mother-daughter

Answer - Click Here:
A &D

7. We can create an index on

A. Foreign key

B. Secondary key

C. Primary key

D. All of above

Answer - Click Here:

8. The relationship between data objects is …

A. Data table

B. Data flow Diagram

C. Data modelling

D. None of these

Answer - Click Here:

9. We can represent optional relationship by

A. O

B. />

C. </

D. ^

Answer - Click Here:

10. Modality is also related to …

A. Mandatory

B. Cardinality

C. Optional

D. Logical

Answer - Click Here:
B &C

11.  Basic data distribution strategy is …

A. Replicated

B. Centralized

C. Partitioned

D. All of the above

Answer - Click Here:

12. Physically arranging records on secondary storage devices of a file is …

A. File organization

B. Integrity constraints

C. Indexes

D. Data distribution strategy

Answer - Click Here:

More MCQs Of Database Systems

  1. SET 1: database design mcqs (database design mcqs )
  2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
  3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
  4. SET 4: database systems mcqs (database systems mcqs)
  5. SET 5: dbms mcqs (dbms mcqs )
  6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
  7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
  8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
  9. SET 9: relational database management system mcqs(relational database management system mcqs)
  10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
  11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
  12. SET 12: relational database management system mcqs (relational database management system mcqs )
  13. SET 13: database mcqs online test (database mcqs online test)
  14. SET 14: database interview questions mcqs (database interview questions mcqs)
  15. SET 15: database developer mcqs (database developer mcqs)
  16. SET 16: database Repeated mcqs (database Repeated mcqs)
  17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
  18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
  19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)

Computer Science Repeated MCQs Book Download

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.