Multiple choice

Transaction X holds a shared lock R. What happens if transaction Y requests for a shared lock on R?

  1. Results in deadlock situation

  2. Immediately granted

  3. Immediately rejected

  4. Granted as is released by X

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

Shared locks are compatible - multiple transactions can hold shared locks on the same resource simultaneously for read operations. Transaction Y's shared lock request on R will be immediately granted. Deadlock requires competing lock types (shared vs exclusive), and shared locks don't wait for other shared locks to be released.