In a high-concurrency database system, two transactions are waiting for each…
TPSC Computer/IT Posts · 2026 · System Analyst
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 495 students.
Sign up free to check your answer
Sign up freeLoading lesson…