Quiz for Normalization

Q1: What is the main goal of normalization?

A. Improve UI B. Reduce memory C. Eliminate redundancy D. Speed up queries

Q2: Which normal form eliminates partial dependency?

A. 1NF B. 2NF C. 3NF D. BCNF

Q3: What is the main purpose of normalization?

A. Reduce redundancy B. Increase performance C. Add indexes D. Use more storage

Q4: Which normal form removes repeating groups?

A. 1NF B. 2NF C. 3NF D. BCNF

Q5: What does 2NF eliminate?

A. Partial dependency B. Transitive dependency C. Redundancy D. Primary key

Q6: What does 3NF eliminate?

A. Composite key B. Partial dependency C. Transitive dependency D. Repeating group

Q7: Which normal form deals with multivalued dependencies?

A. 3NF B. BCNF C. 4NF D. 5NF

Q8: Which of the following is required for a relation to be in 1NF?

A. Atomic attributes B. Foreign key C. Candidate key D. Composite key

Q9: Which form is based on functional dependency?

A. 1NF B. 2NF C. 3NF D. BCNF

Q10: Which of the following is not a goal of normalization?

A. Remove redundancy B. Improve integrity C. Faster performance D. Avoid anomalies

Q11: Which of the following is a transitive dependency?

A. A → B and B → C B. A → C directly C. A → B only D. None of the above

Q12: What is the main issue with unnormalized data?

A. Data integrity issues B. Fewer joins C. Efficient queries D. Ease of reporting

Q13: Which form is the strictest form of normalization?

A. 3NF B. BCNF C. 4NF D. 5NF

Q14: What does BCNF stand for?

A. Boyce-Codd Normal Form B. Basic Column Normal Form C. Binary Column Normal Form D. Boolean-Coded NF

Q15: Which form is violated when a non-key attribute depends on part of a composite key?

A. 1NF B. 2NF C. 3NF D. BCNF

Q16: Which normal form is also known as project-join normal form?

A. 3NF B. 4NF C. 5NF D. BCNF

Q17: Which form deals with join dependency?

A. 4NF B. 5NF C. 3NF D. 2NF

Q18: In which normal form is a relation with no transitive dependency?

A. 1NF B. 2NF C. 3NF D. 4NF

Q19: If a table is in BCNF, then it is also in?

A. 1NF only B. 2NF only C. 3NF and 2NF D. None

Q20: Why is normalization important?

A. It increases redundancy B. It simplifies the schema C. It avoids anomalies D. It reduces indexing

Q21: Which is a characteristic of a good database design?

A. Data duplication B. Redundant columns C. Normalized structure D. Fewer tables

Q22: Which normal form deals with elimination of derived data?

A. 1NF B. 3NF C. 4NF D. 5NF