Back to the 2024 paper
Similar questions
Database Management SystemConsider the transactions T1, T2 and T3 and schedules S1 and S2 given below: T1 : r1 (X); r1(Z); w1 (X); w1 (Z), T2 : r2 (Y); r2 (Z); w2 (Z) T3 : r3 (Y); r3 (X); w3 (Y) S1 : r1 (X); r3(Y); r3(X); r2 (Y); r2(Z); w3(Y); w2 (Z); r1 (Z); w1(X), w1 (Z). S2 : r1 (X); r3 (Y); r2(Y); r3(X); r1(Z); r2(Z); w3 (Y); w1 (X); w2(Z), w1 (Z). Determine which of the above schedules are conflict – serializable.20227mDatabase Management SystemConsider the schedule: R1(X), R2(X), W1(X), W2(X). The schedule is: (i) View serializable only (ii) Conflict serializable (iii) Not serializable (iv) Recoverable20252mDATABASE MANAGEMENT SYSTEMSerializability of concurrent transaction is ensured by - (i) locking - (ii) time stamping - (iii) both (a) and (b) - (iv) none of these20232mDATABASE MANAGEMENT SYSTEMExplain two-phase locking protocol & conflict serializability. | Unit 3 – Transaction Management | Concurrency control.20247m