Practice mode DBMS and SQL

A college keeps a student’s address in separate files for the library and the accounts office, and only the accounts copy is updated after the student moves. Which file-processing problem does this illustrate?

Correct answer A. Data redundancy and inconsistency

Explanation

Storing the same fact in several files is redundancy, and when the copies are updated separately they disagree, which is inconsistency. A DBMS reduces this by keeping one integrated, shared copy. Data isolation is a different problem: data scattered across files in different formats, which makes writing new programs hard. An atomicity problem concerns a partially completed update after a failure.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.