engineering recuitment NIC NIELIT Scientist B 2023 Mock Test DBMS Transaction Serializability of Schedules
Consider the following transactions with data items X and Y initialized to zero:
T1: read (x);
Read (y);
if x = 0 then y: = y + 1;
Write (y);
T2: read (y);
write (x);
If y = 0 then x: x + 1
Write (x);
1
Serializable schedule
2
A schedule that is not conflict serializable
3
A conflict serializable schedule
4
A schedule for which a precedence graph cannot be drawn