Database Normalisation MCQ Test: Database Normalisation MCQs - Practice Questions
1. In the context of database normalization, what is the purpose of the Fifth Normal Form (5NF)?
2. Which normal form ensures that there are no partial dependencies on a composite primary key?
3. Which normal form deals with multi-valued dependencies?
4. What is a composite key in a relational database?
5. In which normal form should a relation be to eliminate partial dependencies?
6. What is the primary goal of database normalisation?
7. What challenges may arise when denormalizing a database for the purpose of optimizing query performance?
8. How can the use of a surrogate key impact the process of data migration in a database?
9. What is the significance of atomicity in database transactions?
10. How does the Boyce-Codd Normal Form (BCNF) differ from the Third Normal Form (3NF) in database normalization?
11. When might you choose to use a recursive relationship in a normalized database?
12. When normalizing a database, what challenges may arise with regards to performance?
13. What is denormalization in database design?
14. In the context of database normalization, how does the process of decomposition contribute to improving data integrity?
15. When might you consider using a non-relational database approach instead of traditional normalization techniques?
16. In the context of database design, what is an anomaly?
17. How does the normalization process contribute to data integrity?
18. What challenges may arise when normalizing a database that contains historical data?
19. What is the role of indexing in a relational database?
20. What is the role of a covering index in optimizing query performance in a normalized database?
21. When normalizing a database, why is it important to consider the nature of the application and its usage patterns?
22. How does normalization contribute to database efficiency?
23. What is a functional dependency in the context of database normalization?
24. Why is the Fourth Normal Form (4NF) important in the context of multivalued dependencies?
25. When is denormalization typically used in a database?
26. When might you consider using a horizontal partitioning strategy in a normalized database?
27. When might it be appropriate to denormalize a database?
28. What is a primary key in a relational database?
29. In the context of database design, what is a superkey?
30. When normalizing a database, what does the Third Normal Form (3NF) address?
31. Which normal form ensures that there are no repeating groups?
32. What is a surrogate key in the context of database design?
33. When might you consider using a composite attribute in a normalized database?
34. When might you use a composite key in a database?
35. In which normal form should a relation be to eliminate transitive dependencies?
36. What is the significance of a transitive dependency in the context of database normalization?
37. What is the purpose of the Sixth Normal Form (6NF) in database normalization?
38. What is the purpose of the Domain-Key Normal Form (DKNF) in database normalization?
39. What is the purpose of the Fourth Normal Form (4NF) in database normalization?
40. What is the purpose of a unique constraint in a database?
41. What is the purpose of the Boyce-Codd Normal Form (BCNF) in database normalization?
42. What is a multivalued dependency in the context of database normalization?
43. Why is it important to avoid update anomalies in a normalized database?
44. Which normal form deals with repeating groups in a relation?
45. How does denormalization impact query performance?
46. What is a candidate key in database normalization?
47. Which normal form ensures that there are no transitive dependencies and no partial dependencies?
48. When might you choose to use a surrogate key over a natural key?
49. What is the significance of a surrogate key in the context of database design?
50. In database normalization, what is a candidate key?