The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.
A)purge
B)erase
C)delete
D)integrity

Question

Quizplus · Accepted Answer

The problem described in the question is commonly known as the "delete anomaly." When a record (or row) is deleted from a database table, related information (in other tables) might be lost if the relationship between those tables is not correctly established. This can result in incomplete or incorrect data remaining in the database. Therefore, the correct procedure for deleting a record should include checking for any dependencies and taking appropriate measures to preserve data integrity.

The Problem of Losing Desired Information from a Database When