What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database? MCQ with Answer and Explanation
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
A. Insertion Anomaly
B. Selection Anomaly
C. Projection Anomaly
D. Deletion Anomaly
Answer: Option D
Solution (By JKSSB Mock Tests)
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.
Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).
No comments yet. Be the first to start the discussion!