The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the
A) update anomaly.
B) insert anomaly.
C) inconsistency anomaly.
D) delete anomaly.

Question

Quizplus · Accepted Answer

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called an update anomaly. This refers to situations where updating one instance of a data item may leave other instances inconsistent or corrupted. For example, if a customer's address is listed in multiple records throughout a database, updating it in one record but not the others could lead to confusion and errors in the system.

The Potential Inconsistency That Could Occur When There Are Multiple