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