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