In a high-concurrency database system, two transactions are waiting for each…
2026
In a high-concurrency database system, two transactions are waiting for each other's locked resources. What is the most effective automatic way for a DBMS to handle this situation ?
- A.
Switching from pessimistic to optimistic locking
- B.
Increase the size of the database buffer cache
- C.
Deadlock detection and victim selection
- D.
Deadlock prevention using spooling
Attempted by 103 students.
Show answer & explanation
Correct answer: C
The scenario describes a deadlock where transactions wait for each other's resources. The most effective automatic DBMS mechanism is deadlock detection followed by victim selection to resolve the conflict.