Curioustab

Home » Database » Managing Multiuser Databases

Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?

Read committed
Read uncommitted
Repeatable read
Serializable

Correct Answer: Repeatable read

← Previous Question Next Question→

More Questions from Managing Multiuser Databases

A transaction in which either all of the database actions occur or none of them do is called:
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
The size of a lock is called:
Locks placed by the DBMS are called ________ .
Which of the following refers to a cursor type where changes of any type and from any source are visible?
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
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?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
The advantage of optimistic locking is that:
A transaction for which all committed changes are permanent is called:

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion