Normalization MCQs

What is the primary goal of normalization in database design?

• To increase redundancy

• To reduce data duplication and improve data integrity

• To make queries faster

• To add more tables to the database

Which of the following is NOT a benefit of normalization?

• Minimizing data redundancy

• Improving query performance

• Reducing update anomalies

• Ensuring data consistency

What is a functional dependency in a database?

• A relationship between two tables

• A constraint that determines the value of one attribute based on another

• A way to normalize a table

• A type of join operation

What does it mean if attribute B is functionally dependent on attribute A?

• The value of B determines the value of A

• The value of A determines the value of B

• A and B have no relationship

• A and B must always have the same value

Which normal form eliminates repeating groups in a table?

• 1NF

• 2NF

• 3NF

• BCNF

What is an "anomaly" in the context of database normalization?

• A type of database index

• An error caused by poorly structured tables

• A valid database operation

• A foreign key constraint

Which type of anomaly occurs when deleting a record unintentionally removes related data?

• Insertion anomaly

• Update anomaly

• Deletion anomaly

• Query anomaly

A table is in 2NF if:

• It is in 1NF and has no partial dependencies

• It is in 1NF and has no transitive dependencies

• It is in 1NF and has no repeating groups

• It is in 3NF and has no functional dependencies

What is a partial dependency?

• A dependency where a non-prime attribute depends on part of a composite primary key

• A dependency where all attributes depend on the primary key

• A dependency between two unrelated tables

• A dependency involving derived attributes

A table is in 3NF if:

• It is in 2NF and has no transitive dependencies

• It is in 2NF and has no partial dependencies

• It is in 1NF and has no repeating groups

• It is in BCNF and has no functional dependencies