Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 10
What is the difference between optimistic and pessimistic locking?
A
They are identical
B
Pessimistic uses no locks
C
Optimistic never conflicts
D
Optimistic checks for conflicts at write time (version column) and retries; pessimistic locks rows upfront (FOR UPDATE)