Question

Transaction T1 holds a lock on resource A and requests a lock on resource
B. Transaction T2 holds a lock on resource B and requests a lock on resource
A. Both transactions remain blocked indefinitely, each waiting on the other. What condition does this represent, and what data structure does a DBMS commonly use to detect it?

A Starvation; detected using a priority inversion table
B Livelock; detected using a two-phase commit log
C Deadlock; detected using a Wait-For Graph, where a cycle indicates deadlock
D A dirty read; detected using the transaction's isolation level setting
E Cascading rollback; detected using a shadow paging mechanism
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)