Consider a schedule of transactions T₁ and T₂:

Here, RX stands for “Read(X)” and WX stands for “Write(X)”. Which one of the following schedules is conflict equivalent to the above schedule?

Consider the following two transactions: T₁ and T₂.

T1: read(A);
               read(B);
               if A=0 then B ← B+1;
               write(B);
T2: read(B);
               read(A);
               if B≠0 then A ← A-1;
               write(A); 
 
Which of the following schemes, using shared and exclusive locks, satisfy the requirements for strict two phase locking for the above transactions? 
      

Consider the following three schedules of transactions T1, T2 and T3. [Notation: In the following NYO represents the action Y (R for read, W for write) performed by transac­tion N on object O.]

(S1)	2RA	2WA	3RC	2WB	3WA	3WC	1RA	1RB	1WA	1WB
(S2)	3RC	2RA	2WA	2WB	3WA	1RA	1RB	1WA	1WB	3WC
(S3)	2RA	3RC	3WA	2WA	2WB	3WC	1RA	1RB	1WA	1WB

Consider three data items D1, D2 and D3 and the following execution schedule of transactions T1, T2 and T3. In the diagram, R(D) and W(D) denote the actions reading and writing the data item D respectively.

Which of the following statements is correct?

Which of the following scenarios may lead to an irrecoverable error in a database system?

Consider the following partial Schedule S involving two transactions T1 and T2. Only the read and the write operations have been shown. The read operation on data item P is denoted by read(P) and the write operation on data item P is denoted by write(P).

Consider a simple checkpointing protocol and the following set of operations in the log.

(start, T₄); (write, T₄, y, 2, 3); (start, T₁); (commit, T₄); (write, T₁, z, 5, 7);
(checkpoint);
(start, T₂); (write, T₂, x, 1, 9); (commit, T₂); (start, T₃); (write, T₃, z, 7, 2);

If a crash happens now and the system tries to recover using both undo and redo operations, what are the contents of the undo list and the redo list

Consider the following transaction involving two bank account x and y.

The constraint that the sum of the accounts x and y should remain constant is that of

Suppose a database schedule S involves transactions T₁, ..., T_n. Construct the precedence graph of S with vertices representing the transactions and edges representing the conflicts. If S is serializable, which one of the following orderings of the vertices of the precedence graph is guaranteed to yield a serial schedule?

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 of them is conflict serializable?

Consider the following schedules involving two transactions. Which one of the following statements is TRUE?

S₁: r₁(X); r₁(Y); r₂(X); r₂(Y); w₂(Y); w₁(X)
S₂: r₁(X); r₂(X); r₂(Y); w₂(Y); r₁(Y); w₁(X)

Consider the following schedule for transactions T1, T2 and T3:

Which one of the schedules below is the correct serialization of the above?

Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?

I. 2-phase locking
II. TIme-stamp ordering

Consider the following schedule S of transactions T1, T2, T3, T4:

Which one of the following statements is CORRECT?