Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. What is the purpose of a unique constraint in a database?
2. Which normal form deals with the removal of transitive dependencies?
3. When might you consider using a non-relational database approach instead of traditional normalization techniques?
4. Which normal form allows only full functional dependencies?
5. What is the impact of a denormalized database on data modification anomalies?
6. Which normal form deals with multi-valued dependencies?
7. What challenges may arise when normalizing a database that contains historical data?
8. What is the advantage of using foreign keys in a database?
9. How does normalization contribute to database efficiency?
10. How can the presence of too many indexes impact the performance of a normalized database?
11. What is the purpose of a foreign key in a relational database?
12. In the context of database design, what is an anomaly?
13. When might you choose to use a surrogate key over a natural key?
14. What is denormalization in database design?
15. What is a surrogate key in a database?
16. What is the significance of a transitive dependency in the context of database normalization?
17. What is the role of a covering index in optimizing query performance in a normalized database?
18. Why is it important to avoid update anomalies in a normalized database?
19. In database normalization, what is a candidate key?
20. When normalizing a database, what challenges may arise with regards to performance?