Database MCQ’s

By: Prof. Fazal Rehman Shamil
Last modified on September 23rd, 2020

Database MCQ’s

1. Table with similar records is

A. Record

B. Field

C. File

D. None

Answer - Click Here:
C

2. SQL is a

A. Software

B. Structured language

C. Unstructured language

D. Object oriented language

Answer - Click Here:
B

3. Retrival  and storage of data is

A. Managing output

B. Data manipulation

C. Data capturing

D. All of these

Answer - Click Here:
A

4. Process of merging relations is …

A. View relations

B. View data models

C. View integration

D. None of these

Answer - Click Here:
C

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

A. Relationship

B. Entity

C. Attribute

D. Process

Answer - Click Here:
A

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:
D

8. The relationship between data objects is …

A. Data table

B. Data flow Diagram

C. Data modelling

D. None of these

Answer - Click Here:
C

9. We can represent optional relationship by

A. O

B. />

C. </

D. ^

Answer - Click Here:
A

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:
D

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:
A

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