Question: In the following, when a transaction TT performs an operation x = x + ax = x + a , then TT reads xx into

In the following, when a transaction TT performs an operation x=x+ax=x+a, then TT reads xx into some register, adds a to the register content then stores register content into xx.
A transaction schedule is serializable if its effect is equivalent to that of some serial schedule. Consider a bookkeeping operation consisting of two transactions T1T1 and T2T2 that are required to keep the sum A+B+CA+B+C unchanged. Which of the following pairs of transactions will always result in a serializable schedule? I. T1 : Lock A; A = A -10; Unlock A; B = B +10; T2: Lock B; B = B -20; Unlock B; C=C+20; II. T : A=A-10; Lock B; B=B+10; Unlock B; T2: Lock B; B=B-20; Unlock B; C=C +20; III. T1:Lock A; A = A -10; Unlock A; B = B +10; T2: Lock A; B = B -20; Unlock A; C=C+20; OPTIONS: I only
II only
III only
I and II

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!