Let transaction T1 have obtained a shared mode lock S on data item Q and transaction T2 has obtained an exclusive mode lock X on data item R…

Let transaction T1 have obtained a shared mode lock S on data item Q and transaction T2 has obtained an exclusive mode lock X on data item R. Consider the following statements.

I: T1 can read Q but cannot write Q.

II: T2 can read R but cannot write R.

Which of the above statements is / are valid?

  1. a) Only I
  2. b) Only II
  3. c) Both I and II
  4. d) Neither I nor II

From the Combined Bank Senior Officer October 2021 – Preliminary exam, question 24 of 108.

More from this paper