Back to the 2022 paper
Similar questions
Database Management SystemExplain concurrency control problems such as lost update, dirty read, and unrepeatable read.20257mData MiningOutlier are (i) legitimate data objects (ii) illegitimate data objects (iii) legitimate and illegitimate data objects (iv) None of the above20222mDatabase Management SystemExplain the immediate update and deferred update of recovery techniques.20187mOperating SystemIn which of the following page replacement policy Belady's anomaly occurs? (i) FIFO (ii) LRU (iii) LFU (iv) NRU20222m
PreviousConsider 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.NextWith example discuss candidate key, super key, primary key and foreign key.