Saturday, 5 September 2009

Performance Tuning - Question 058.

Which of these is not a condition that would lead to a deadlock in the current session?

A . The other session is waiting for a resource that is locked in an incompatible mode by the current session.

B . Another session is holding a lock on a resource in an incompatible mode.

C. The other session is waiting for a resource that is also requested by a third session.

D . The resource is required by the current session.

Explanation:

Answer C: The conditions Another session is holding a lock on a resource in an incompatible mode, The resource is required by the current session, and The other session is waiting for a resource that is locked in an incompatible mode by the current session are the prerequisite conditions that make a deadlock happen. Multiple users can wait for the same resource without causing a deadlock. However, multiple users could also be involved in a deadlock if the correct (but unlikely) conditions occur.

No comments:

Post a Comment