Advanced SQL Developer — Hard
Key points
- Optimistic locking is based on the assumption of rare conflicts
- It does not acquire locks on read rows
- Validation occurs at update time using a version column or timestamp
- Conflicting transactions are aborted if another transaction modified the row
Ready to go further?
Related questions