SQL Normalization MCQ 1NF 2NF 3NF BCNF Practice Questions

Direction: Choose the correct option

What is database normalization?

A. Increasing redundancy

B. Adding indexes

C. Speeding queries

D. Organizing data to reduce redundancy

Direction: Choose the correct option

What is 1NF (First Normal Form)?

A. Primary key required

B. No duplicate rows

C. Foreign key added

D. Atomic values, no repeating groups

Direction: Choose the correct option

What is 2NF (Second Normal Form)?

A. 1NF + no partial dependencies

B. No duplicates

C. Unique rows

D. 1NF + no transitive dependencies

Direction: Choose the correct option

What is 3NF (Third Normal Form)?

A. Foreign key added

B. 1NF + no duplicates

C. Primary key required

D. 2NF + no transitive dependencies

Direction: Choose the correct option

Why normalize databases?

A. Increase speed

B. Reduce redundancy, avoid anomalies

C. Simplify queries

D. Add more tables

Quipoin Menu