Multiple choice

Assume that transaction A holds a shared lock R. If transaction B also requests for a shared lock R, it will

  1. be a deadlock situation

  2. immediately be granted

  3. immediately be rejected

  4. be granted as soon as it is released by A

  5. depend on the wish of transaction A

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Since transaction A holds only a shared lock on R, any number of transactions can read the data from the requested item using shared locking. Hence, B's request will be granted immediately.