Question 16 Two transactions T1 and T2 are given as T1: r1(X)w1(X)r1(Y)w1(Y) T2: r2(Y)w2(Y)r2(Z)w2(Z) where ri(V) denotes a read operation by transaction Ti on a variable […]
Question 21 Given the following Pascal-like program segment Procedure A; x,y: integer; Procedure B; x,z: real S1 end B; Procedure C; i: integer; S2 end C; […]
Question 24 Consider the following relations P(X,Y,Z), Q(X,Y,T) and R(Y,V). How many tuples will be returned by the following relational algebra query? ∏x(P.Y=R.Y ∧ R.V=V2)(P × R)) – ∏x(Q.Y=R.Y ∧ […]