Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. What is the purpose of normalization in databases?
2. What is an example of a transitive dependency in a database?
3. When might a functional dependency be considered trivial in the context of database normalization?
4. What is the role of indexing in a relational database?
5. What is the purpose of a foreign key in a relational database?
6. Which normal form deals with multi-valued dependencies?
7. When might you choose to use a surrogate key over a natural key?
8. In the context of database design, what is a superkey?
9. When might you consider using a non-relational database approach instead of traditional normalization techniques?
10. When normalizing a database, why is it important to consider the nature of the application and its usage patterns?
11. When is denormalization typically used in a database?
12. How does the presence of null values impact the normalization process?
13. In the context of database design, what is an anomaly?
14. What is a candidate key in database normalization?
15. What challenges may arise when denormalizing a database for the purpose of optimizing query performance?
16. What is denormalization in database design?
17. When normalizing a database, what challenges may arise with regards to performance?
18. In the context of database normalization, how does the process of decomposition contribute to improving data integrity?
19. Which normal form deals with the removal of transitive dependencies?
20. Why is the Fourth Normal Form (4NF) important in the context of multivalued dependencies?