Question

________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction.

(a) Read uncommitted

(b) Serializable

(c) Repeatable read

(d) Read committed

I had been asked this question during an online interview.

I would like to ask this question from Transaction Isolation Levels in section Transactions of RDBMS

Answer 1

Correct option is (c) Repeatable read

Easy explanation: Repeatable read allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction. However, the transaction may not be serializable with respect to other transactions.