Database Normalization Quiz

What is the purpose of normalization in a database?

• To increase data redundancy

• To create insertion anomalies

• To ensure data dependencies make sense

• To decrease data integrity

What is the main problem without normalization in a database?

• Data integrity

• Data inconsistency

• Data loss

• Data redundancy

What type of anomaly occurs when some attributes or data items are to be inserted into the database without the existence of other attributes?

• Partial Dependency

• Insert Anomaly

• Update Anomaly

• Delete Anomaly

In which normal form does a row of data cannot contain repeating groups of data?

• Third Normal Form

• Second Normal Form

• First Normal Form

• Boyce and Codd Normal Form

What is the purpose of Second Normal Form?

• To eliminate data redundancy

• To ensure data dependencies make sense

• To remove transitive functional dependency from the table

• To remove partial dependency of any column on the primary key

What is the main characteristic of Boyce and Codd Normal Form (BCNF)?

• It deals with certain types of anomalies not handled by 3NF

• It allows multi-valued dependencies

• It is less strict than 3NF

• It is a lower version of the Third Normal Form

What is the purpose of Fourth Normal Form (4NF)?

• To avoid redundancy

• To ensure lossless joining

• To remove transitive dependency from the table

• To eliminate multi-valued dependency

What is the main characteristic of Fifth Normal Form (5NF)?

• It allows redundancy

• It is a lower version of the Fourth Normal Form

• It allows partial dependency of columns on the primary key

• It is also known as Project-join normal form (PJ/NF)

What is the purpose of Third Normal Form (3NF)?

• To ensure lossless joining

• To eliminate data redundancy

• To remove transitive functional dependency from the table

• To ensure data dependencies make sense

What type of anomaly occurs when duplicate data is updated only in one place and not in all instances?

• Delete Anomaly

• Partial Dependency

• Insert Anomaly

• Update Anomaly