What happens if a piece of data is stored in two places in the db?
2023
What happens if a piece of data is stored in two places in the db?
- A.
Storage space is wasted and changing the data in one spot will cause data inconsistency
- B.
Changing the data in one spot will cause data inconsistency
- C.
Storage space is wasted
- D.
More than one of the above
- E.
None of the above
Attempted by 1607 students.
Show answer & explanation
Correct answer: A
When data is stored in multiple places in a database, it leads to two main issues: (1) Wasted storage space because the same data is duplicated, and (2) Data inconsistency, which occurs when updates are made to one copy but not the others. This violates the principle of data integrity and makes the database unreliable.