Question

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

A it will result in a deadlock situation
B it will immediately be granted
C it will immediately be rejected
D it will immediately be rejected
Answer & Explanation
Option: [D]