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

DBMS Normalization MCQs

#1. What is a multivalued dependency in the context of database normalization?

#2. Which normal form allows a relation to be in 3NF and removes transitive dependencies?

#3. What does the term "transitive dependency" mean in the context of normalization?

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

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

#6. Which normal form allows a relation to be in 5NF and eliminates join dependencies?

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

#8. Which normal form eliminates partial and transitive dependencies on a composite primary key?

#9. What does the term "superkey" refer to in the context of database normalization?

#10. Which normal form allows a relation to be in 1NF and removes repeating groups?

#11. What is a composite key in the context of database normalization?

#12. Which normal form allows a relation to be in 2NF and removes partial dependencies?

#13. What is the key difference between 4NF (Fourth Normal Form) and BCNF (Boyce-Codd Normal Form)?

#14. What is a functional dependency in the context of database normalization?

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

#16. What is a transitive dependency in the context of database normalization?

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

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

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

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

Results

Categories MCQ