A(n) _____ occurs when data are stored redundantly in a database and only some of the instances are updated when a change is needed.
A) error
B) update anomaly
C) data integrity concern
D) storage efficiency
E) none of these

Question

Quizplus · Accepted Answer

A update anomaly occurs when there is redundancy in the data stored in a database, and some instances are updated while others are not. This can lead to inconsistencies in the data and affect data integrity. Therefore, B is the correct answer. A, C, and D are incorrect because they do not specifically describe the phenomenon of redundant data causing inconsistencies in updates.

A(n) _____ Occurs When Data Are Stored Redundantly in a Database