All challenges
Multiple ChoiceHard 30s

Optimistic Locking

Optimistic locking typically uses:
Options
  1. 1A row-level FOR UPDATE lock is always acquired before every single update
  2. 2A single in-process mutex guarded by the application server protects the row
  3. 3A version column checked on update to detect concurrent writes
  4. 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.

Play this in a 3-minute battle