MCQ King
2 – Database Design MCQ
Best of luck!
1 / 25
1. What is the primary goal of database design in SQL Server?
2 / 25
2. In the context of database design, what does the term “normal form” refer to?
3 / 25
3. Which normal form requires that a table be in second normal form (2NF) and that no non-key attribute is partially dependent on the primary key?
4 / 25
4. What is the primary purpose of the entity-relationship model in database design?
5 / 25
5. Which entity-relationship model component represents an entity or object in the database schema?
6 / 25
6. In the entity-relationship model, what does a “relationship” represent?
7 / 25
7. Which normal form requires that a table be in second normal form (2NF) and that it has no transitive dependencies?
8 / 25
8. In the context of SQL Server, what do “syntax conventions” refer to?
9 / 25
9. Which normal form requires that a table be in third normal form (3NF) and that it has no multivalued dependencies?
10 / 25
10. What is the primary objective of applying normalization techniques in database design?
11 / 25
11. In the entity-relationship model, what is an “attribute”?
12 / 25
12. Which normal form requires that a table be in first normal form (1NF) and that all non-key attributes are functionally dependent on the primary key?
13 / 25
13. What is the primary goal of the “entity-relationship diagram” in the entity-relationship model?
14 / 25
14. Which entity-relationship model component represents a unique identifier for an entity?
15 / 25
15. In the context of database design, what does “denormalization” refer to?
16 / 25
16. Which normal form requires that a table be in fourth normal form (4NF) and that it has no multi-valued dependencies?
17 / 25
17. What is the primary purpose of the “foreign key” in database design?
18 / 25
18. Which normal form requires that a table be in third normal form (3NF) and that it has no transitive dependencies or partial dependencies?
19 / 25
19. What is the primary role of “candidate keys” in the entity-relationship model?
20 / 25
20. In the context of database design, what is the “primary key” of a table?
21 / 25
21. What is the primary purpose of the “relationship degree” in the entity-relationship model?
22 / 25
22. Which entity-relationship model component represents a property or characteristic of an entity?
23 / 25
23. In the entity-relationship model, what does a “weak entity” rely on to identify its records uniquely?
24 / 25
24. What is the primary objective of the “dependency diagram” in the entity-relationship model?
25 / 25
25. In the context of SQL Server, what do “syntax conventions” refer to?
Your score is
Restart quiz