engineering recuitment NIC NIELIT Scientist B 2023 Mock Test DBMS Concurrency Control Timestamp Based Ordering Protocol
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
I only
2
II only
3
Both I and II
4
Neither I nor II