Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. When might you choose to use a recursive relationship in a normalized database?
2. When normalizing a database, what does the Third Normal Form (3NF) address?
3. How can the presence of too many indexes impact the performance of a normalized database?
4. Which normal form ensures that there are no repeating groups?
5. In which normal form should a relation be to eliminate partial dependencies?
6. What is a candidate key in database normalization?
7. What is the purpose of a foreign key in a relational database?
8. In the context of database normalization, how does the process of decomposition contribute to improving data integrity?
9. What is the purpose of the Boyce-Codd Normal Form (BCNF) in database normalization?
10. When might you choose to use a surrogate key over a natural key?
11. How does denormalization impact query performance?
12. In which normal form should a relation be to eliminate transitive dependencies?
13. When might a functional dependency be considered trivial in the context of database normalization?
14. What is the purpose of the Domain-Key Normal Form (DKNF) in database normalization?
15. In the context of database design, what is a composite key?
16. Which normal form deals with the removal of transitive dependencies?
17. Which normal form allows only full functional dependencies?
18. What is the role of indexing in a relational database?
19. In the context of database design, what is an anomaly?
20. When might it be appropriate to use database partitioning in a normalized database environment?
21. How does normalization contribute to database efficiency?
22. Which normal form ensures that there are no transitive dependencies and no partial dependencies?
23. What is the role of materialized views in a normalized database environment?
24. When normalizing a database, what challenges may arise with regards to performance?
25. What is the significance of a transitive dependency in the context of database normalization?
26. In the context of database design, what is a superkey?
27. What is the significance of a surrogate key in the context of database design?
28. What is a surrogate key in the context of database design?
29. When might you use a composite key in a database?
30. What challenges may arise when denormalizing a database for the purpose of optimizing query performance?
31. How can the use of a surrogate key impact the process of data migration in a database?
32. Which normal form eliminates transitive dependencies?
33. When might you consider using a composite attribute in a normalized database?
34. What is the impact of a denormalized database on data modification anomalies?
35. When might you consider using a horizontal partitioning strategy in a normalized database?
36. When is denormalization typically used in a database?
37. What is the significance of atomicity in database transactions?
38. How does the normalization process contribute to data integrity?
39. Which normal form deals with repeating groups in a relation?
40. What is a primary key in a relational database?