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

Question

Quizplus · Accepted Answer

Pessimistic locks are placed assuming that a conflict will occur and are obtained before accessing a resource to prevent other transactions from accessing it simultaneously. This is in contrast to optimistic locks, which assume that conflicts are rare and allow multiple transactions to access a resource at the same time, checking for conflicts only when committing changes. Dynamic locks are locks that are acquired and released dynamically during a transaction, while explicit and implicit locks refer to how locks are obtained (manually or automatically).

Locks That Are Placed Assuming That a Conflict Will Occur