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