Home » MCQs » DBMS MCQs » DBMS Transaction MCQs

What is TRUE about Isolation?

20. What is TRUE about Isolation?

1. By using the data used during a transaction, the second transaction will not be able to use it until the first has been executed.
2. The data item X cannot be accessed by any other transaction T2 until the transaction T1 is completed and the data item X is used by the transaction T1.
3. It enforced the isolation property via its concurrency control subsystem.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Isolation -

1. By using the data used during a transaction, the second transaction will not be able to use it until the first has been executed.
2. The data item X cannot be accessed by any other transaction T2 until the transaction T1 is completed and the data item X is used by the transaction T1.
3. It enforced the isolation property via its concurrency control subsystem.