The Update Anomaly occurs when more than one occurrence of a specific data item in a database exists. Update Anomaly happens when one or more instances of doubled data is updated, but not all. It is is a data discrepancy which resulted from data that is no longer needed or useful..