Consider the following two statements about database transaction schedules: I.…

PYQ GATE 2019

Consider the following two statements about database transaction schedules:

I. Strict two-phase locking protocol generates conflict serializable schedules that are also recoverable.

II. Timestamp-ordering concurrency control protocol with Thomas’ Write Rule can generate view serializable schedules that are not conflict serializable.

Which of the above statements is/are TRUE?

  1. A.

    I only

  2. B.

    II only

  3. C.

    Both I and II

  4. D.

    Neither I nor II

Attempted by 567 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…