Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q181: Which anomaly may lead to data inconsistency if not all instances of data are updated?
- A: Insert Anomaly
- B: Delete Anomaly
- C: Update Anomaly
- D: Merge Anomaly
View Answer
C
Q182: Fill in the blank: The presence of an insert anomaly indicates that a row cannot be added without adding ________ data.
- A: related
- B: redundant
- C: historical
- D: calculated
View Answer
A
Q183: In the context of anomalies, what is typically lost due to a delete anomaly?
- A: Historical data
- B: Unrelated data
- C: Customer data
- D: Product data
View Answer
C
Q184: Which type of anomaly can result in multiple updates of the same data item, potentially leading to inconsistencies?
- A: Insert Anomaly
- B: Delete Anomaly
- C: Update Anomaly
- D: Redundancy Anomaly
View Answer
C
Q185: Fill in the blank: Update anomalies occur when the same information is expressed on multiple rows and ________.
- A: only some instances are updated
- B: all instances are updated
- C: no instances are updated
- D: redundant data is removed
View Answer
A
Q186: Which of the following is NOT a type of anomaly mentioned?
- A: Insert Anomaly
- B: Delete Anomaly
- C: Update Anomaly
- D: Merge Anomaly
View Answer
D
Q187: What is the primary cause of anomalies according to the content?
- A: Large database size
- B: Poor database design and planning
- C: High data redundancy
- D: Complex queries
View Answer
B
Q188: Fill in the blank: An update anomaly can lead to ________ across the database if not all instances are updated.
- A: data consistency
- B: data integrity
- C: data redundancy
- D: data inconsistency
View Answer
D
Q189: What is the primary goal of database normalization?
- A: Increase redundancy
- B: Reduce data redundancy
- C: Improve data retrieval speed
- D: Simplify data entry
View Answer
B
Q190: Which normal form requires that no two rows of data contain repeating groups of information?
- A: First Normal Form (1NF)
- B: Second Normal Form (2NF)
- C: Third Normal Form (3NF)
- D: Fourth Normal Form (4NF)
View Answer
A