Data redundancy:
A)can lead to a number of data anomalies
B)is useful in ensuring the integrity of data.
C)provides a useful backup function in a database.
D)none of the options are correct.

Question

Quizplus · Accepted Answer

Data redundancy refers to the unnecessary duplication of data in a database. This can result in a number of data anomalies such as inconsistencies, update/delete anomalies, and wastage of storage space. Therefore, A is the correct choice. B and C are not accurate, as data redundancy does not ensure data integrity nor provide a backup function, respectively.

Data Redundancy