Question

Which of the following statement is correct?
(1) Data Redundancy can be handled by inconsistency.
(2) Redundancy in data may lead to its inconsistency.
(3) Inconsistency in data may lead to Redundancy.
(4) Data inconsistency can be handled by Redundancy.

Answer 1

4)data inconsistency can be handled by redundancy

Answer 2

The correct answer is OPTION 2: Redundancy in data may lead to its inconsistency.

• The database business frequently employs terms like "data redundancy" and "data consistency."
• The use of suitable database architecture reduces data redundancy and consistency.
• Redundancy refers to the fact that identical bits of data are kept in many locations throughout the database. This is referred to as data redundancy.
• When there are several tables with the same information in different forms. The phrase for this problem is data inconsistency.
• Simply said, it means that data about the same thing or person is duplicated across multiple files.
• As a result, erroneous and useless data may arise. Redundancy in data leads to inconsistency.