> > >

SQL MCQs

What is a phantom read?

Phantom reads do not exist

All reads from the data under snapshot is a phantom read

A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the second query is different from the first.

When values in the data set before the end of the transaction are changed, giving incorrect/wrong data back.

Answer

Correct Answer: A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the second query is different from the first.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it