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

Add a Comment