The advantage of optimistic locking is that:
A. the lock is obtained only after the transaction has processed.
B. the lock is obtained before the transaction has processed.
C. the lock never needs to be obtained.
D. transactions that are best suited are those with a lot of activity.
Answer: Option A
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