Which situation occurs when two transactions each have a lock on a resource that the other transaction needs in order to complete?
A)blocking lock
B)multiple lockout
C)exclusive lock
D)deadlock

Question

Quizplus · Accepted Answer

This is a scenario of a deadlock where both transactions are waiting for a lock held by the other and neither can proceed further. This can result in a system-wide halt and requires intervention to resolve.

Which Situation Occurs When Two Transactions Each Have a Lock