Which type of lock assumes that no conflicts will occur?
A) Optimistic locks
B) Granular locks
C) Explicit locks
D) Shared locks
E) Open locks

Question

Quizplus · Accepted Answer

Optimistic locks assume that conflicts are rare, and multiple transactions can access the same data simultaneously without causing conflicts. This approach minimizes the locking overhead and increases concurrency. Other types of locks, such as granular locks and explicit locks, assume that conflicts are possible and prevent concurrent access to the data to avoid conflicts. Shared locks and open locks are not valid lock types.

Which Type of Lock Assumes That No Conflicts Will Occur