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