Database Normalization Quiz

What is the main purpose of normalization?

• Speed up transactions

• Create more tables

• Eliminate data redundancy

• Improve physical design

Which of the following is true about a surrogate key?

• It has no business meaning

• It must be unique and meaningful

• It is a combination of foreign keys

• It cannot be indexed

First Normal Form (1NF) requires:

• Unique rows

• Atomic values in columns

• Foreign keys

• Functional dependencies

A table is in 2NF if it is in 1NF and:

• All attributes are atomic

• No partial dependency exists

• Transitive dependency exists

• There is a surrogate key

Which dependency is removed in 3NF?

• Functional dependency

• Partial dependency

• Transitive dependency

• All of the above

Which of the following is not a type of normal form?

• 1NF

• 2NF

• 5DF

• BCNF

What is the need for denormalization?

• To normalize data further

• To improve read performance

• To reduce anomalies

• To enforce data integrity

BCNF is an advanced version of:

• 3NF

• 2NF

• 4NF

• 1NF

Which of the following can be used as a surrogate key?

• Natural key

• Auto-increment integer

• Composite key

• Foreign key

Which normal form deals with multi-valued dependencies?

• 2NF

• 3NF

• 4NF

• BCNF