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