Question

Which of the following advantages of DBMS ensures that changes in data are reflected across all tables?

• A. Data Sharing
• B. Organised Storage
• C. Data Consistency
• D. Minimal Data Redundancy

Hint:

Data consistency ensures that changes made to the database are reflected consistently across all related tables, maintaining data integrity.

Answer 1

The Correct Option is C

Data consistency in a Database Management System (DBMS) ensures that when data is updated in one place, the changes are reflected across all related tables. This reduces errors and ensures the integrity of the data.
Step 2: Analyzing the options.

• (A) Data Sharing: Incorrect. Data sharing refers to the ability of users to access and use data across different locations, but it does not directly ensure that changes are reflected across all tables.
• (B) Organised Storage: Incorrect. Organised storage refers to the structured arrangement of data, but it does not guarantee that changes are automatically updated in all related tables.
• (C) Data Consistency: Correct. Data consistency ensures that changes in one part of the database are propagated to all related tables, maintaining the accuracy and integrity of the data.
• (D) Minimal Data Redundancy: Incorrect. While minimizing data redundancy is an advantage of a DBMS, it does not directly ensure that changes are reflected across all tables.

Step 3: Conclusion.
Therefore, the correct answer is (C) Data Consistency, as it ensures that changes in data are reflected across all tables. Final Answer:} Data Consistency.