Ace Test Series | DBMS

Question

In multiple Granularity locking protocol at a particular node transaction T1 is holding SIX LOCK. When transaction T2 is also requesting a lock, at that node which other lock is allowed.

1. I S
2. I X
3. S
4. SIX
5. X

Answer 1

CORRECT ANSWER IS IS OPTION(A).

Comments

only shared lock is allowed due to it’s (only read property) while in  exclusive lock read and write cant be done until previous transaction  release the lock.