Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. How does the presence of null values impact the normalization process?
2. What is denormalization in database design?
3. When might it be appropriate to use database partitioning in a normalized database environment?
4. In database normalization, what is a candidate key?
5. What is a candidate key in database normalization?
6. Which normal form ensures that there are no transitive dependencies and no partial dependencies?
7. What challenges may arise when normalizing a database that contains historical data?
8. When might you consider using a non-relational database approach instead of traditional normalization techniques?
9. What is a composite key in a relational database?
10. What is a foreign key in a relational database?
11. What is an example of a transitive dependency in a database?
12. Which normal form deals with the removal of transitive dependencies?
13. Which normal form eliminates transitive dependencies?
14. When normalizing a database, why is it important to consider the nature of the application and its usage patterns?
15. What is the impact of a denormalized database on data modification anomalies?
16. How can the presence of too many indexes impact the performance of a normalized database?
17. What is the purpose of the Second Normal Form (2NF) in database normalization?
18. What is the role of a covering index in optimizing query performance in a normalized database?
19. What is a functional dependency in the context of database normalization?
20. When is denormalization typically used in a database?
21. Which normal form ensures that there are no repeating groups?
22. What is the significance of a transitive dependency in the context of database normalization?
23. Which normal form deals with multi-valued dependencies?
24. In which normal form should a relation be to eliminate transitive dependencies?
25. What is the role of materialized views in a normalized database environment?
26. What is the significance of atomicity in database transactions?
27. When normalizing a database, what does the Third Normal Form (3NF) address?
28. What is the primary goal of database normalization?
29. What is the purpose of a unique constraint in a database?
30. Which normal form allows only full functional dependencies?