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