Database Normalization Quiz

What is the primary goal of database normalization?

• To structure data to prevent anomalies

• To store data in a flat file format

• To create complex relationships

• To increase data redundancy

Which of the following is NOT a characteristic of a normalized database?

• Data redundancy

• Improved data integrity

• Reduced memory consumption

• Faster query performance

What does 'atomic' data refer to?

• Data that is duplicated

• Data that cannot be broken down further

• Data that can be broken down further

• Data that is stored in multiple tables

Which normal form requires that all data must be atomic?

• Zero Form

• Third Normal Form (3NF)

• Second Normal Form (2NF)

• First Normal Form (1NF)

What is a requirement of the Second Normal Form (2NF)?

• All non-key attributes must depend on the primary key

• No duplicate records are allowed

• It must be in First Normal Form

• All attributes must have unique names

What does Referential Integrity ensure?

• All data must be stored in one table

• Data can be broken down into smaller parts

• Data can be duplicated across tables

• Foreign keys must match primary keys

Which of the following is a benefit of normalization?

• More complex data relationships

• Faster data queries

• Larger database size

• Increased data duplication

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

• It does not require a primary key

• It eliminates fields that do not depend on the primary key

• It allows for transitive dependencies

• It requires duplicate records

Which of the following describes a flat file?

• A file that stores data in a simple text format

• A file that uses complex relationships

• A file with multiple tables

• A file that contains redundant data

What happens when data is not normalized?

• Query performance improves

• Redundancy increases

• Data integrity improves

• Storage costs decrease