Normalization in Databases Quiz

What is the primary goal of normalization?

• To increase data redundancy

• To reduce data redundancy and inconsistencies

• To store all data in a single table

• To improve database security

Which of the following best describes normalization?

• The process of converting a database into a spreadsheet

• A method for structuring data to minimize duplication

• A technique used to improve database security

• A process used to increase redundancy for backup purposes

Which of the following is a characteristic of a well-normalized database?

• High redundancy

• No foreign keys

• Minimal data duplication

• Single large table storing all information

What is the primary key of a table?

• A unique attribute that identifies each row

• A foreign key referencing another table

• A set of attributes used for indexing

• An optional attribute used for sorting

A foreign key is used to...

• Identify unique rows in a table

• Enforce referential integrity between tables

• Index database records for faster searches

• Store backup copies of primary keys

Which of the following is NOT a type of database key?

• Primary key

• Foreign key

• Redundant key

• Candidate key

What is a composite key?

• A single attribute that serves as the primary key

• A key that is created by encrypting another key

• A key composed of two or more attributes

• A key used only for indexing purposes

The process of breaking a large table into smaller related tables is called...

• Denormalization

• Normalization

• Aggregation

• Indexing

What is the first step in the normalization process?

• Identifying the functional dependencies

• Splitting tables into smaller ones

• Removing all primary keys

• Removing duplicate columns

Which of the following problems can normalization help to prevent?

• Unauthorized access

• Data redundancy and update anomalies

• SQL injection attacks

• System crashes