Database MCQ’s

1. Table with similar records is
A. Record

B. Field

C. File

D. None

2. SQL is a
A. Software
B. Structured language
C. Unstructured language
D. Object oriented language

3. Retrival  and storage of data is
A. Managing output
B. Data manipulation
C. Data capturing
D. All of these

4. Process of merging relations is …
A. View relations
B. View data models
C. View integration
D. None of these

5. In  E-R diagram, an oval is for
A. Relationship
B. Entity
C. Attribute
D. Process

6. Example of one-to-many relationship in E-R diagram
A. Father-son
B. Teacher-student
C. Country-capital
D. Mother-daughter

7. We can create an index on
A. Foreign key
B. Secondary key
C. Primary key
D. All of above

8. The relationship between data objects is …
A. Data table
B. Data flow Diagram
C. Data modelling
D. None of these

9. We can represent optional relationship by
A. O
B. />
C. </
D. ^

10. Modality is also related to …
A. Mandatory
B. Cardinality
C. Optional
D. Logical

11.  Basic data distribution strategy is …
A. Replicated
B. Centralized
C. Partitioned
D. All of the above

12. Physically arranging records on secondary storage devices of a file is …
A. File organization
B. Integrity constraints
C. Indexes
D. Data distribution strategy

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)