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]