Normalization & Schema Design · SQL SQL
What type of data anomaly occurs when deleting a record inadvertently causes other unrelated domain information to be lost from the database?
Practice question from Normalization & Schema Design (SQL SQL), with the correct answer and a step-by-step solution.
easy · MCQ · Q-1B087D
What type of data anomaly occurs when deleting a record inadvertently causes other unrelated domain information to be lost from the database?
- A.Insertion anomaly
- B.Update anomaly
- C.Deletion anomalyCorrect answer
- D.Concurrency anomaly
Solution
A deletion anomaly occurs when the deletion of a row unintentonally removes critical data that was stored alongside it due to tight coupling or lack of normalization.
More from Normalization & Schema Design
- What is the primary objective of normalizing a database to the Third Normal Form (3NF)?
- A relation R(A, B, C, D) has the functional dependencies F = {AB -> C, C -> D, D -> A}. What is the highest normal form satisfied by R?
- Which of the following describes a Boyce-Codd Normal Form (BCNF) violation?
- When is intentional denormalization typically justified in a production relational database?
Practise more SQL
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed