If transaction A holds a shared lock on R and if transaction B also requests a…
2018
If transaction A holds a shared lock on R and if transaction B also requests a shared lock on R, it will —
- A.
result in a deadlock situation
- B.
immediately be granted
- C.
immediately be rejected
- D.
be granted as soon as it is released by A
Attempted by 403 students.
Show answer & explanation
Correct answer: B
Shared locks are compatible with other shared locks. So multiple transactions can read the same data item simultaneously.
A video solution is available for this question — log in and enroll to watch it.