Assume that transactions are executed at REPEATABLE READ. Give an example in which a phantom occurs when a transaction executes a DELETE statement to delete a set of tuples satisfying some predicate, P.

What will be an ideal response?


After the DELETE statement is executed, a concurrent transaction inserts a newtuple
that satisfies P.

Computer Science & Information Technology

You might also like to view...

Which partition type is installed as part of the Linux boot sector?

A. Primary B. Extended C. Logical D. Cache

Computer Science & Information Technology

Android is an open-source platform, based on yet another open platform, Linux, and is owned by Google. Because Android is open source, device manufacturers can (and do) alter or customize it as they see fit; there are differences among the implementations from various vendors. Google writes the core Android code and occasionally releases new versions (naming each major update after a desert or candy of some sort), at which point vendors customize it to add unique hardware features or provide a branded look and feel.

What will be an ideal response?

Computer Science & Information Technology

Parsing of data can happen both in HF and Indexer.

A. Only HF B. No C. Yes

Computer Science & Information Technology

Which protocol is the preferred alternative to POP3 and runs on TCP port 143?

A. SMTP B. IMAP4 C. POP4 D. Web-based e-mail

Computer Science & Information Technology