Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable
Answer: Option C
This Question Belongs to Database >> Managing Multiuser Databases
Related Questions on Managing Multiuser Databases
Locks placed by command are called ________ .
A. implicit locks
B. explicit locks
C. exclusive locks
D. shared locks
Which of the following locks the item from change but not from read?
A. Implicit lock
B. Explicit lock
C. Exclusive lock
D. Shared lock
A. Nonrepeatable read
B. Phantom read
C. Dirty read
D. Consistent read
A transaction for which all committed changes are permanent is called:
A. atomic.
B. consistent.
C. isolated.
D. durable.
Join The Discussion