Locks that are placed assuming that a conflict will not occur are called:
A)dynamic.
B)explicit.
C)implicit.
D)optimistic.
E)pessimistic.

Question

Quizplus · Accepted Answer

Locks that are placed assuming that a conflict will not occur are called optimistic. Optimistic locking assumes that conflicts between concurrent transactions are rare, and therefore, transactions proceed as if no other transactions are taking place. If a conflict occurs, the transaction can be rolled back and restarted.

Locks That Are Placed Assuming That a Conflict Will Not