A consistent database state is one in which all _____.
A) tables have foreign keys
B) data integrity constraints are satisfied
C) table are normalized
D) SQL statements only update one table at a time

Question

Quizplus · Accepted Answer

A consistent database state is one in which all data integrity constraints are satisfied. This means that the data in the database is reliable and accurate, and that it can be used to generate correct reports and analysis. Foreign keys and table normalization are helpful in achieving this goal, but they alone cannot guarantee consistency. SQL statements updating one table at a time is a good practice for maintaining consistency, but it is not a requirement.

A Consistent Database State Is One in Which All _____