in Databases reopened by
708 views
1 vote
1 vote

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

  1. result in deadlock situation
  2. immediately be granted
  3. immediately be rejected
  4. be granted as soon as it is released by $A$
in Databases reopened by
708 views

2 Answers

0 votes
0 votes
option b will be correct because in shared mode transactions can only read data.
0 votes
0 votes
When one transaction has shared lock, other transaction can get shared lock on it. So B is correct.

Had A had exclusive lock, D would be correct on request of both shared and exclusive lock. No possibility of deadlock as there will be no circular wait when we are requesting single resource.
Answer:

Related questions