Question

What is the characteristic of a transaction where every transaction reads only the items that are written by committed transactions?

1) Atomicity
2) Consistency
3) Isolation
4) Durability

Answer 1

The characteristic referring to a transaction that reads only data from committed transactions is Isolation, which is a key principle of the ACID properties in database management.

Step-by-step explanation:

The characteristic of a transaction where every transaction reads only the items that are written by committed transactions is Isolation. Isolation, one of the properties of the ACID principles, ensures that the operations of a transaction are not visible to other transactions until the transaction is committed. This principle is necessary to prevent dirty reads, which occur when a transaction reads data that has not yet been committed and may still be rolled back. In the context of the ACID properties of database transactions, isolation ensures that the execution of transactions is independent of other transactions. Specifically, in a situation where transactions only read items that have been successfully written (committed) by other transactions, it reflects a level of isolation, as each transaction sees a consistent snapshot of the database.