Question: 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?
Options
A : Nonrepeatable read
B : Phantom read
C : Dirty read
D : Consistent read
Managing Multiuser Databases - General Questions more questions
Which of the following is not a factor in determining....
SQL Server program code that is executed after an SQL....
Which of the following refers to the SQL Server transaction....
Locks placed by command are called ________ .
Which of the following locks the item from change but....
A transaction for which all committed changes are permanent is....
In this instance, dirty reads are disallowed, while nonrepeatable reads....
Which of the following occurs when a transaction rereads data....
The advantage of optimistic locking is that:
Which of the following refers to a cursor type that....
Advanced SQL - General Questions more Online Exam Quiz
Introduction to SQL - General Questions
JDBC, Java Server Pages, and MySQL - General Questions
Logical Database Design - General Questions
Managing Databases with Oracle - General Questions
SQL Server 2000 - General Questions
Modeling Data in the Organization - General Questions
Object-Oriented Database - General Questions
Object-Oriented Data Modeling - General Questions