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...

If a device does not receive an IP address from a DHCP server, the device may resort to what kind of IP address?

A. APIPA B. random IP address C. public IP address D. dynamic IP address

Computer Science & Information Technology

When a report has been created and used in Access, it can be formatted and laid out differently than the original design

Indicate whether the statement is true or false

Computer Science & Information Technology

Setting this property to No displays the object as a tabbed object

a. Modal b. Pop-up c. Pull-down

Computer Science & Information Technology

Computer programming is also known as ______.

A. debugging B. coding C. programming D. none of the above

Computer Science & Information Technology