Which database anomaly describes the necessity to update the exact same data value in multiple independent rows, creating a risk of data inconsistency? MCQ with Answer and Explanation
Which database anomaly describes the necessity to update the exact same data value in multiple independent rows, creating a risk of data inconsistency?
A. Update Anomaly
B. Selection Anomaly
C. Structural Anomaly
D. Insertion Anomaly
Answer: Option A
Solution (By JKSSB Mock Tests)
An Update Anomaly occurs when data is redundantly duplicated across rows, requiring changes to be made to every copy, risking inconsistencies if any row is missed.
Explanation:
A relational database table can have exactly one primary key constraint defined, which uniquely identifies each record and strictly forbids NULLs.
No comments yet. Be the first to start the discussion!