ExamVeda
Login
Home
Managing Multiuser Databases
?

A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

Answer & Solution
Correct Answer: Option B
Phantom read does not refer to modifications or deletions of existing rows.

It occurs when a transaction reads a set of rows that satisfy a condition, and then, upon re-execution of the same query, finds additional rows (phantoms) that were inserted by another committed transaction.

This is different from non-repeatable reads, where a transaction rereads data and finds that it has been modified or deleted by another transaction.

Therefore, the statement given in the question describes a non-repeatable read, not a phantom read.
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Dr KD
Dr KD 1 year ago
The Answer should be True