Home » MCQs » DBMS MCQs » DBMS Transaction MCQs

What is TRUE about Consistency?

18. What is TRUE about Consistency?

1. As a result of integrity constraints, the database remains consistent before and after the transaction.
2. In most cases, a database remains either in its previous stable state or in a new stable state following the execution of a transaction.
3. Every transaction undergoes a consistent database instance, which is the consistent property of databases.
4. All of the above

Answer: D) All of the above

Explanation:

In case of consistency -

1. As a result of integrity constraints, the database remains consistent before and after the transaction.
2. In most cases, a database remains either in its previous stable state or in a new stable state following the execution of a transaction.
3. Every transaction undergoes a consistent database instance, which is the consistent property of databases.