DATA MODELING AND NORMALIZATION EXAM
LATEST 2026 UPDATE 100 QUESTIONS AND
DETAILED VERIFIED ANSWERS FROM ACTUAL
EXAMS TEST GRADE A+
Q1. What is the main goal of data modeling?
A. Increase hardware speed
B. Organize and structure data efficiently
C. Encrypt database records
D. Delete redundant data
Answer: B
Rationale: Data modeling focuses on organizing and structuring data in a way that
supports efficient storage, retrieval, and relationships.
Q2. Which of the following is NOT a data model?
A. Hierarchical model
B. Network model
C. Relational model
D. Compilation model
Answer: D
Rationale: Compilation model is related to programming languages, not database
structure.
Q3. In ER modeling, what does ER stand for?
A. Entity Relationship
B. External Reference
,C. Entity Record
D. Extended Relation
Answer: A
Rationale: ER stands for Entity-Relationship, used to represent data relationships.
Q4. A primary key must be:
A. Null
B. Duplicate
C. Unique
D. Optional
Answer: C
Rationale: A primary key uniquely identifies each record in a table.
Q5. What does normalization aim to reduce?
A. Processing speed
B. Data redundancy
C. Memory size
D. Table creation
Answer: B
Rationale: Normalization minimizes data duplication and improves consistency.
Q6. Which normal form removes repeating groups?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer: A
,Rationale: First Normal Form ensures atomic values and removes repeating
groups.
Q7. A table is in 2NF when it is in 1NF and:
A. Has no transitive dependency
B. Has no partial dependency
C. Has no primary key
D. Has duplicate rows
Answer: B
Rationale: 2NF removes partial dependency on part of a composite key.
Q8. Which normal form removes transitive dependency?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
Answer: C
Rationale: Third Normal Form eliminates transitive dependencies.
Q9. A foreign key is used to:
A. Encrypt data
B. Link two tables
C. Delete records
D. Sort data
Answer: B
Rationale: Foreign keys establish relationships between tables.
, Q10. Which model represents data as tables?
A. Hierarchical
B. Network
C. Relational
D. Object-oriented
Answer: C
Rationale: The relational model uses tables (relations) to store data.
Q11. What is a composite key?
A. Single attribute key
B. Two or more attributes forming a key
C. Foreign key only
D. Encrypted key
Answer: B
Rationale: A composite key uses multiple attributes to uniquely identify records.
Q12. Which of the following is a data anomaly?
A. Encryption
B. Insertion inconsistency
C. Indexing
D. Normalization
Answer: B
Rationale: Data anomalies include insertion, update, and deletion inconsistencies.
Q13. Which normal form is also called Boyce-Codd Normal Form?
A. 1NF
B. 2NF
LATEST 2026 UPDATE 100 QUESTIONS AND
DETAILED VERIFIED ANSWERS FROM ACTUAL
EXAMS TEST GRADE A+
Q1. What is the main goal of data modeling?
A. Increase hardware speed
B. Organize and structure data efficiently
C. Encrypt database records
D. Delete redundant data
Answer: B
Rationale: Data modeling focuses on organizing and structuring data in a way that
supports efficient storage, retrieval, and relationships.
Q2. Which of the following is NOT a data model?
A. Hierarchical model
B. Network model
C. Relational model
D. Compilation model
Answer: D
Rationale: Compilation model is related to programming languages, not database
structure.
Q3. In ER modeling, what does ER stand for?
A. Entity Relationship
B. External Reference
,C. Entity Record
D. Extended Relation
Answer: A
Rationale: ER stands for Entity-Relationship, used to represent data relationships.
Q4. A primary key must be:
A. Null
B. Duplicate
C. Unique
D. Optional
Answer: C
Rationale: A primary key uniquely identifies each record in a table.
Q5. What does normalization aim to reduce?
A. Processing speed
B. Data redundancy
C. Memory size
D. Table creation
Answer: B
Rationale: Normalization minimizes data duplication and improves consistency.
Q6. Which normal form removes repeating groups?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer: A
,Rationale: First Normal Form ensures atomic values and removes repeating
groups.
Q7. A table is in 2NF when it is in 1NF and:
A. Has no transitive dependency
B. Has no partial dependency
C. Has no primary key
D. Has duplicate rows
Answer: B
Rationale: 2NF removes partial dependency on part of a composite key.
Q8. Which normal form removes transitive dependency?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
Answer: C
Rationale: Third Normal Form eliminates transitive dependencies.
Q9. A foreign key is used to:
A. Encrypt data
B. Link two tables
C. Delete records
D. Sort data
Answer: B
Rationale: Foreign keys establish relationships between tables.
, Q10. Which model represents data as tables?
A. Hierarchical
B. Network
C. Relational
D. Object-oriented
Answer: C
Rationale: The relational model uses tables (relations) to store data.
Q11. What is a composite key?
A. Single attribute key
B. Two or more attributes forming a key
C. Foreign key only
D. Encrypted key
Answer: B
Rationale: A composite key uses multiple attributes to uniquely identify records.
Q12. Which of the following is a data anomaly?
A. Encryption
B. Insertion inconsistency
C. Indexing
D. Normalization
Answer: B
Rationale: Data anomalies include insertion, update, and deletion inconsistencies.
Q13. Which normal form is also called Boyce-Codd Normal Form?
A. 1NF
B. 2NF
