Two-phase locking ensures conflict serializability but can deadlock while transactions hold and request locks. Basic timestamp ordering enforces timestamp-consistent conflicting operations and aborts violations rather than waiting in lock cycles. Thus II alone satisfies both, B.
More Transactions and Concurrency Control questions
GATE 2010 CS (CS1) Q52– Find the equivalent serial order for this schedule, listed from first operation to last:
GATE 2015 CS (CS2) Q31– A transaction transfers money between accounts x,y: The requirement that x+y remain…
GATE 2015 CS (CS2) Q39– A simple-checkpoint recovery log contains: A crash occurs now. Choose the undo and redo…
GATE 2015 CS (CS3) Q51– A partial schedule is: Time T1 T2 --- --- --- 1 read(A) 2 write(A) 3 read(C) 4 write(C) 5…
GATE 2021 CS (CS2) Q42– Schedule S is R2(Y),R1(X),R3(Z),R1(Y),W1(X),R2(Z),W2(Y),R3(X),W3(Z). P: S is…
GATE 2026 CS (CS2) Q20– Consider concurrent execution of two transactions T 1 and T 2 in a DBMS, both of which…