Multiple ChoiceHard 30s
Optimistic Locking
Optimistic locking typically uses:
Options
- 1A row-level FOR UPDATE lock is always acquired before every single update
- 2A single in-process mutex guarded by the application server protects the row
- 3A version column checked on update to detect concurrent writes
- 4A database lock held for the entire duration of the whole HTTP request
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.