Database - Managing Multiuser Databases - Discussion

Discussion Forum : Managing Multiuser Databases - General Questions (Q.No. 3)
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Nonrepeatable read
Phantom read
Dirty read
Consistent read
Answer: Option
No answer description is available. Let's discuss.
3 comments Page 1 of 1.

Harshal said:   4 years ago
A phantom read occurs when in the course of a transaction, new rows are added or removed by another transaction to the records being read.

Dinesh said:   4 years ago
Phantom read means?

Anupam said:   1 decade ago
Phantom reads occur when an insert or a delete action is performed against a row that belongs to a range of rows being read by a transaction.

Post your comments here:

Your comments will be displayed after verification.