ibps-so 2022 · Question 8 of 59

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?

ATransactions T1, T2, and T4 can simultaneously hold S-locks on the same resource.Correct
BTransaction T3 can obtain an X-lock while T1 holds an S-lock.
CTransaction T4 can read the resource while T3 holds an X-lock.
DAn S-lock and an X-lock are compatible on the same resource.
EShared and exclusive locks are interchangeable.

Answer: A. Transactions T1, T2, and T4 can simultaneously hold S-locks on the same resource.

Official answer key verified. Detailed explanation coming soon.

Source: IBPS SO IT Officer Mains Memory Based 2022 - Adda247 · memory-based

Practice the full ibps-so 2022 paper

Timed test with all 59 questions, just like the real exam.

ibps-so 2022 · Question 8 of 59

ATransactions T1, T2, and T4 can simultaneously hold S-locks on the same resource.Correct
BTransaction T3 can obtain an X-lock while T1 holds an S-lock.
CTransaction T4 can read the resource while T3 holds an X-lock.
DAn S-lock and an X-lock are compatible on the same resource.
EShared and exclusive locks are interchangeable.

Official answer key verified. Detailed explanation coming soon.

Source: IBPS SO IT Officer Mains Memory Based 2022 - Adda247 · memory-based

Practice the full ibps-so 2022 paper

Timed test with all 59 questions, just like the real exam.