Assume transaction A holds a share lock R. If a transaction B also requests for a shared lock on R.
1
it will result in a deadlock situation.
2
it will immediately be granted.
3
it will immediately be rejected.
4
it will be granted as soon as it is released by A.
5
None of the above