Give an example of a schedule that could be produced at SNAPSHOT isolation in which there are two transactions that execute concurrently but do not have the same snapshot number and do not see the same snapshot of the database. (Hint: the schedule can contain more than two transactions.)
What will be an ideal response?
T1 : r (x) w(x) commit
T2 : r (y) r (x) w(y) commit
T3 : r (y) r (x) commit
T2 and T3 are concurrent but T3 has a snapshot number one greater than that of T2 because T1 committed before T3 started. Thus T3 reads the same value of y that T2 does but reads a different value of x
You might also like to view...
One of the basic techniques of number theory is the __________ algorithm which is a simple procedure for determining the greatest common divisor of two polynomials. ?
Fill in the blank(s) with the appropriate word(s).
An advantage of ____ image maps is that, when a user clicks a link, the information does not have to be sent over the network or dial-up connection.
A. server-side B. client-side C. target-side D. Both A and B
A page layout technique that often uses a percentage value for width is called _____________.
a. ice b. fixed c. fluid d. wireframe
A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value
A) Find command B) Find & Replace command C) wildcard character D) Replace command