Advanced SQL Developer — Hard
Key points
- Predicate locking focuses on logical conditions rather than individual rows
- Prevents phantom reads by blocking inserts that would affect the predicate
- Enhances data integrity in SERIALIZABLE isolation level
Ready to go further?
Related questions