Question

Which of the following concurrency control methods avoids deadlocks entirely but can reduce concurrency by blocking transactions at start?

A Two-phase locking (2PL) with deadlock detection
B Timestamps ordering protocol (e.g., Thomas’ write rule)
C Strict 2PL with wait-die/wound-wait
D Conservative (static) 2PL — acquire all locks before execution
E Optimistic concurrency control with validation
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)