An update anomaly forces you to change data in multiple records,such as when you need to change the name of a product and you must change multiple rows to make the update.

Question

Quizplus · Accepted Answer

This statement is accurate. An update anomaly can occur when data is duplicated (exists more than once) and there is a need to update a value for that data. This can result in the need to change multiple records at once, potentially causing data inconsistencies or errors if not handled properly.

An Update Anomaly Forces You to Change Data in Multiple