Consider the situation that the transaction 'P' holds shared key lock X. Also, other transaction 'Q' requests for shared key lock X, then :
A. request will be immediately granted
B. the deadlock situation is created
C. request will be rejected after some time
D. request will be granted at it is released by P.
Answer:A
Consider the situation that the transaction 'P' holds shared key lock X. Also, other transaction 'Q' requests for shared key lock X, then :
A. request will be immediately granted B. the deadlock situation is created C. request will be rejected after some time D. request will be granted at it is released by P.