Question

Snapshot isolation is used to give

(a) Transaction a snapshot of the database

(b) Database a snapshot of the transaction

(c) Database a snapshot of committed values in the transaction

(d) Transaction a snapshot of the database and Database a snapshot of committed values in the transaction

Answer 1

Correct answer is (d) Transaction a snapshot of the database and Database a snapshot of committed values in the transaction

Best explanation: The data values in the snapshot consist only of values written by committed transactions.