Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. In the context of database design, what is a composite key?
2. When might you consider using a horizontal partitioning strategy in a normalized database?
3. When normalizing a database, why is it important to consider the nature of the application and its usage patterns?
4. What is the purpose of the Domain-Key Normal Form (DKNF) in database normalization?
5. What is the impact of a denormalized database on data modification anomalies?
6. When might you choose to use a recursive relationship in a normalized database?
7. When is denormalization typically used in a database?
8. What is a surrogate key in the context of database design?
9. In database normalization, what is a candidate key?
10. In the context of database design, what is an anomaly?
11. What is a functional dependency in the context of database normalization?
12. When normalizing a database, what does the Third Normal Form (3NF) address?
13. In which normal form should a relation be to eliminate transitive dependencies?
14. When might it be appropriate to denormalize a database?
15. When might you consider using a composite attribute in a normalized database?
16. What is an example of a transitive dependency in a database?
17. What is the role of indexing in a relational database?
18. What is a surrogate key in a database?
19. How does the presence of null values impact the normalization process?
20. What is a foreign key in a relational database?
21. When might you consider using a non-relational database approach instead of traditional normalization techniques?
22. What is the advantage of using foreign keys in a database?
23. What is the primary goal of database normalisation?
24. Why is the Fourth Normal Form (4NF) important in the context of multivalued dependencies?
25. What is denormalization in database design?
26. Which normal form ensures that there are no partial dependencies on a composite primary key?
27. How can the presence of too many indexes impact the performance of a normalized database?
28. What is the role of a covering index in optimizing query performance in a normalized database?
29. In which normal form should a relation be to eliminate partial dependencies?
30. What is the purpose of a unique constraint in a database?
31. What is the role of a foreign key constraint in database design?
32. When might you use a composite key in a database?
33. How does denormalization impact query performance?
34. What is the purpose of a foreign key in a relational database?
35. What is a composite key in a relational database?
36. When might it be appropriate to use database partitioning in a normalized database environment?
37. What is the significance of a transitive dependency in the context of database normalization?
38. Why is it important to avoid update anomalies in a normalized database?
39. What is the primary goal of database normalization?
40. Which normal form ensures that there are no repeating groups?