schedules
GATE CSE & IT · Transactions · 2007-2021
Study anchor
Korth — Database System Concepts
Relational model, SQL, normalization, transactions
Practice action
Start latest PYQPYQs in this concept
All concepts →Let r i (z) and w i (z) denote read and write operations respectively on a data item z by a transaction T i . Consider the following two schedules. S 1 : r 1 (x) r 1 (y) r 2 (x) r...
Consider the transactions T1, T2, and T3 and the schedules S1 and S2 given below. T1 : r1 (X) ; r1 (Z) ; w1 (X) ; w1 (Z) T2 : r2 (X) ; r2 (Z) ; w2 (Z) T3 : r3 (X) ; r3 (X) ; w3 (Y)...
Consider the following four schedules due to three transactions (indicated by the subscript) using read and write on a data item x, denoted by r(x) and w(x) respectively. Which one...
Consider two transactions T 1 and T 2 and four schedules S 1 , S 2 , S 3 , S 4 of T 1 and T 2 as given below: T 1 : R 1 [ x ] W 1 [ x ] W 1 [ y ] T 2 : R 2 [ x ] R 2 [ y ] W 2 [ y...
Consider the following three schedules of transactions T 1 , T 2 and T 3 . [ Notation: In the following NYO represents the action Y (R for read, W for write) performed by transact...
Consider the following schedules involving two transactions. Which one of the following statements is TRUE? S 1 : r 1 (X); r 1 (Y); r 2 (Y); r 2 (X); w 2 (Y); w 1 (X); S 2 : r 1 (X...