Database Normalization Principles Quiz

Submit

2. Which of the following best describes the relationship between normalization and database performance?

Normalization always improves performance

Normalization reduces redundancy but may require more joins

Normalization has no effect on performance

Normalization eliminates the need for indexes

Submit

4. What type of anomaly occurs when deleting a row unintentionally removes information about a different entity?

Insertion anomaly

Update anomaly

Deletion anomaly

Referential anomaly

5. True or False: A table in 3NF is guaranteed to be free of all update anomalies.

True

False

6. Which normalization form requires that for every functional dependency X → Y, X must be a candidate key?

Third Normal Form

Boyce-Codd Normal Form

Fourth Normal Form

Fifth Normal Form

Submit

8. What is a foreign key?

An attribute that uniquely identifies rows in the same table

An attribute that references a primary key in another table

A key that is no longer used in a database

An encrypted version of a primary key

9. True or False: Every attribute in a normalized table must be a candidate key.

True

False

10. Which of the following is a characteristic of Fourth Normal Form (4NF)?

Eliminates partial dependencies

Eliminates transitive dependencies

Eliminates non-trivial multivalued dependencies

Eliminates all functional dependencies

11. What is the primary goal of database normalization?

Reduce data redundancy and improve data integrity

Increase query execution speed

Simplify user interfaces

Maximize storage capacity

12. What is denormalization?

The process of removing all redundancy from a database

Intentionally introducing redundancy to improve query performance

Converting a normalized database back to an unnormalized state

Splitting a table into multiple smaller tables

13. True or False: Boyce-Codd Normal Form (BCNF) is stricter than Third Normal Form.

True

False

Submit

15. In the context of normalization, what is a candidate key?

A key that is being considered but not yet implemented

A minimal set of attributes that uniquely identifies a row

A foreign key that references another table

A key used only for backup purposes

16. Which normal form eliminates transitive dependencies?

First Normal Form

Second Normal Form

Third Normal Form

Boyce-Codd Normal Form

17. True or False: A table with a composite primary key can violate 2NF if a non-key attribute depends on only part of the key.

True

False

Submit

19. Which type of dependency occurs when a non-key attribute depends on another non-key attribute?

Functional dependency

Transitive dependency

Partial dependency

Multivalued dependency

Submit

DataSys+ Database Normalization Principles Quiz

1. A ____ is a set of related facts about a single entity or relationship.

2.

What first name or nickname would you like us to use?

2. Which of the following best describes the relationship between normalization and database performance?

3. A ____ is a constraint that ensures the referential integrity between two related tables.

4. What type of anomaly occurs when deleting a row unintentionally removes information about a different entity?

5. True or False: A table in 3NF is guaranteed to be free of all update anomalies.

6. Which normalization form requires that for every functional dependency X → Y, X must be a candidate key?

7. In normalization, a ____ is the minimal set of attributes needed to uniquely identify a row.

8. What is a foreign key?

9. True or False: Every attribute in a normalized table must be a candidate key.

10. Which of the following is a characteristic of Fourth Normal Form (4NF)?

11. What is the primary goal of database normalization?

12. What is denormalization?

13. True or False: Boyce-Codd Normal Form (BCNF) is stricter than Third Normal Form.

14. A functional dependency X → Y exists if the value of Y is determined by the value of ____.

15. In the context of normalization, what is a candidate key?

16. Which normal form eliminates transitive dependencies?

17. True or False: A table with a composite primary key can violate 2NF if a non-key attribute depends on only part of the key.

18. A relation is in Second Normal Form (2NF) if it is in 1NF and contains no ____.

19. Which type of dependency occurs when a non-key attribute depends on another non-key attribute?

20. A table is in First Normal Form (1NF) if all attributes are ____.