PrepAway - Latest Free Exam Questions & Answers

what action will the deadlock detector take when it "wakes up" and discovers the deadlock?

Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to
30 and both applications were started at the same time, what action will the deadlock detector take
when it “wakes up” and discovers the deadlock?

PrepAway - Latest Free Exam Questions & Answers

A.
It will randomly pick an application and rollback its current transaction

B.
Itwill rollback the current transactions of both applications

C.
It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock
has not been resolved

D.
It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an
application and rollback its current transaction

One Comment on “what action will the deadlock detector take when it "wakes up" and discovers the deadlock?


Leave a Reply