Assume transaction A holds a share lock R. If a transaction B also requests for a shared lock on R.

A it will result in deadlock situation.
B it will immediately be granted.
C it will immediately be rejected.
D it will be granted as soon as it is released by A.
Answer & Explanation
Option: [D]

Your Valuable Comments Please...

Useful Computer Science EBooks