Question

Explain The Phantom Phenomenon. Why May This Phenomenon Lead To An Incorrect Concurrent Execution Despite The Use Of The Two-phase Locking Protocol?

Answer 1

Answer:

Why may this phenomenon lead to an incorrect concurrent execution despite the use of the two-phase locking protocol? The phantom phenomenon arises when two transaction logically conflict even though they do not lock a common data item. This usually happens due to insertion or deletion.