Consider concurrent execution of two transactions $T_1$ and $T_2$ in a DBMS, both of which access a data object $A$. For these two transactions to not conflict on $A$, which one of the following statements must be true?
Correct answer: (A) Both $T_1$ and $T_2$ only read $A$
Explanation
Two operations conflict if they are from different transactions, access the same data item, and at least one of them is a write. Therefore, the only non-conflicting case is when both transactions only read $A$. Hence, option (A) is correct.
More Transactions and Concurrency Control questions
GATE 2025 CS (CS1) Q15– A schedule of three database transactions T 1, T 2, and T 3 is shown. R i(A) and W i(A)…
GATE 2025 CS (CS2) Q27– An audit of a banking transactions system has found that on an earlier occasion, two joint…
GATE 2025 CS (CS2) Q53– Consider the database transactions T1 and T2, and data items X and Y. Which of the…
GATE 2024 CS (CS1) Q46– Consider the read-write schedule S over three transactions T 1,T 2,T 3: S: r 1(z); w 1(z);…
GATE 2024 CS (CS2) Q19– Once the DBMS informs the user that a transaction has been successfully completed, its…
GATE 2024 CS (CS2) Q27– Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?