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
More than one of the above
5
None of the above