Assume all transactions are attempting to access the same database resource.…
PYQ IBPS SO CRP SPL-XII (2022)
Assume all transactions are attempting to access the same database resource.
Transaction | Operation Requested | Lock Type Requested |
|---|---|---|
T1 | Read | Shared (S-lock) |
T2 | Read | Shared (S-lock) |
T3 | Write | Exclusive (X-lock) |
T4 | Read | Shared (S-lock) |
Based on standard DBMS lock compatibility rules, which of the following statements is correct?
- A.
Transactions T1, T2, and T4 can simultaneously hold S-locks on the same resource.
- B.
Transaction T3 can obtain an X-lock while T1 holds an S-lock.
- C.
Transaction T4 can read the resource while T3 holds an X-lock.
- D.
An S-lock and an X-lock are compatible on the same resource.
- E.
Shared and exclusive locks are interchangeable.
Attempted by 56 students.
Sign up free to check your answer
Sign up freeLoading lesson…

