Practice
Learn
← Quit
0 / 0 correct
Databases
Medium
1 of 21
How does optimistic concurrency control usually detect a conflicting update?
A
UPDATE ... WHERE id = ? AND version = ? and treats zero affected rows as a conflict
B
It serializes all writes through one thread
C
It takes an exclusive lock before reading the row
D
It compares row checksums nightly