Assume that transactions are executed at REPEATABLE READ. Give an example in which a phantom occurs when a transaction executes a SELECT statement that specifies the value of the primary key in the WHERE clause.

What will be an ideal response?


The requested tuple is not there when the SELECT statement is executed but is inserted
by a concurrent transaction before the transaction commits.

Computer Science & Information Technology

You might also like to view...

List nodes normally are not necessarily stored in contiguous memory. Rather, they’re ________ contiguous.

a. physically b. approximately c. comparably d. logically

Computer Science & Information Technology

The ____________ fstream member function opens a file stream and connects the stream variable to a physical file whose name is the argument to the function.

a) ``` close( ) ``` b) ``` overloaded operator <<( ) ``` c) ``` open( ) ``` d) ``` eof( ) ``` e) ``` flush( ) ```

Computer Science & Information Technology

What is the difference between hard and soft instructions?

What will be an ideal response?

Computer Science & Information Technology

Which of the following is not a standard for wireless Ethernet networks?

A. 802.11n B. 802.11g C. 802.11zx D. 802.11ac

Computer Science & Information Technology