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?

  1. A.

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

  2. B.

    Transaction T3 can obtain an X-lock while T1 holds an S-lock.

  3. C.

    Transaction T4 can read the resource while T3 holds an X-lock.

  4. D.

    An S-lock and an X-lock are compatible on the same resource.

  5. E.

    Shared and exclusive locks are interchangeable.

Attempted by 56 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Prelims

Loading lesson…