Normalization in DBMS Quiz

What is the primary goal of normalization in DBMS?

• Minimize redundancy and anomalies

• Increase data redundancy

• Improve query execution speed

• Convert all relations to a single table

Which of the following anomalies does normalization help to eliminate?

• Insertion anomaly

• Deletion anomaly

• Update anomaly

• All of the above

What is the process of dividing large tables into smaller tables while maintaining data consistency called?

• Denormalization

• Indexing

• Normalization

• Partitioning

Which of the following best describes a functional dependency?

• A relationship between two tables

• A constraint between two attributes

• A method to index data

• A foreign key constraint

Which of the following is not a normal form in DBMS?

• 1NF

• 3.5NF

• BCNF

• 5NF

A table is in First Normal Form (1NF) if it does not contain:

• Repeating groups or multi-valued attributes

• Foreign keys

• Primary keys

• Derived attributes

Which of the following tables violates 1NF?

• A table where each attribute contains atomic values

• A table with composite primary keys

• A table with a column storing multiple email addresses per row

• A table with foreign key constraints

What is the most appropriate way to bring a table into 1NF?

• Remove all functional dependencies

• Remove multi-valued attributes and store them in separate rows

• Introduce a foreign key

• Create a composite primary key

Which condition must be met for a table to be in 2NF?

• It should be in 1NF

• It should have no partial dependencies

• Both a and b

• None of the above

A partial dependency exists when:

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

• A primary key depends on a foreign key

• An attribute depends on another attribute

• A table has a composite foreign key