A consistent database state is .
A)one in which all tables have foreign keys
B)one in which all data integrity constraints are satisfied
C)one in which all tables are normalized
D)one in which all 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, which means that the data in the database is accurate, complete, and valid according to the rules defined by the database schema. Having foreign keys and normalized tables can contribute to data integrity, but they are not sufficient on their own to ensure a consistent database state. Similarly, SQL statements can update multiple tables at once without violating data integrity, as long as they are designed properly.

A Consistent Database State Is