Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. How does the Boyce-Codd Normal Form (BCNF) differ from the Third Normal Form (3NF) in database normalization?
2. What is a candidate key in database normalization?
3. What is a foreign key in a relational database?
4. Which normal form deals with the removal of transitive dependencies?
5. When might you choose to use a recursive relationship in a normalized database?
6. What is the advantage of using foreign keys in a database?
7. When might you choose to use a surrogate key over a natural key?
8. When might a functional dependency be considered trivial in the context of database normalization?
9. In the context of database normalization, what is the purpose of the Fifth Normal Form (5NF)?
10. Which normal form ensures that there are no transitive dependencies and no partial dependencies?
11. What is a multivalued dependency in the context of database normalization?
12. What is an example of a transitive dependency in a database?
13. When might you use a composite key in a database?
14. What is the purpose of the Fourth Normal Form (4NF) in database normalization?
15. What is the purpose of a foreign key in a relational database?
16. When normalizing a database, why is it important to consider the nature of the application and its usage patterns?
17. What is the purpose of the Boyce-Codd Normal Form (BCNF) in database normalization?
18. When normalizing a database, what challenges may arise with regards to performance?
19. Which normal form allows only full functional dependencies?
20. When might it be appropriate to use database partitioning in a normalized database environment?
21. What is the purpose of the Domain-Key Normal Form (DKNF) in database normalization?
22. What is denormalization in database design?
23. Which normal form deals with multi-valued dependencies?
24. When normalizing a database, what does the Third Normal Form (3NF) address?
25. What is the primary goal of database normalisation?
26. What is the significance of a transitive dependency in the context of database normalization?
27. When might you consider using a horizontal partitioning strategy in a normalized database?
28. Which normal form deals with repeating groups in a relation?
29. What is the purpose of normalization in databases?
30. What is the role of indexing in a relational database?