Database Management Systems (DBMS)
What is the name for a situation in which two transactions are each waiting for the other to release a lock, preventing progress?
- A. Transaction
- B. Database trigger
- C. Database index
- D. Transaction deadlock ✓
Correct answer
D. Transaction deadlock
Explanation
Transaction deadlock refers to a situation in which two transactions are each waiting for the other to release a lock, preventing progress.