Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

DBMS Normalization MCQs

#1. What is normalization in the context of database management?

#2. Which normal form ensures that non-key attributes are fully functionally dependent on the primary key?

#3. In which normal form is a relation if it is in 2NF and all non-key attributes are fully functionally dependent on the primary key?

#4. Which of the following is a reason for normalizing a database?

#5. What does the term "functional dependency" mean in the context of normalization?

#6. Which normal form deals with partial dependencies on a composite primary key?

#7. In which normal form are non-prime attributes fully functionally dependent on every candidate key of the relation?

#8. Which of the following is a multivalued dependency?

#9. Which normal form allows only full functional dependencies between the primary key and other attributes?

#10. What does BCNF stand for in the context of normalization?

#11. Which normal form eliminates the possibility of a transitive dependency between non-key attributes?

#12. What is the primary objective of normalization in database design?

#13. In which normal form are attributes dependent only on the primary key?

#14. What does the term "candidate key" refer to in normalization?

#15. Which normal form allows a relation to be in 3NF and removes transitive dependencies between non-prime attributes?

#16. What is the process of decomposing a relation into smaller, more manageable relations called?

#17. Which normal form allows a relation to be in 2NF and removes partial dependencies on a composite primary key?

#18. Which normal form eliminates transitive dependencies and ensures that a relation is in 3NF?

#19. What is the goal of normalization in database design?

#20. Which normal form allows a relation to be in 4NF and removes multivalued dependencies?

Categories MCQ