Assume that transactions are executed at REPEATABLE READ. Give an example in which an UPDATE statement executed by one transaction causes a phantom in an UPDATE statement executed in another.
What will be an ideal response?
The UPDATE statement in the first transaction updates all tuples that satisfy predicate
P, and the UPDATE statement in the second updates a tuple in such a way that its
newvalue satisfies P.
Computer Science & Information Technology
You might also like to view...
What is the function of the Transport layer of the OSI model?
What will be an ideal response?
Computer Science & Information Technology
Does the TCP client terminate or reset the connection, when it gives up with trying establishing a connection?
What will be an ideal response?
Computer Science & Information Technology