A consistent database 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 is one in which all data integrity constraints are satisfied. This means that all the data in the database meets the required standards and rules, including primary and foreign keys, unique constraints, and other data validation rules. While having foreign keys and normalized tables can help ensure consistency, they are not the only factors. Additionally, SQL statements updating only one table at a time may be a good practice for maintaining data consistency, but it does not necessarily guarantee a consistent database.

A Consistent Database Is ____