Q:
What is the difference between Cursor Stability and Repeatable Read isolation levels?
Answer
CURSOR STABILITY:
- CS is a row level locking
- Acquires an exclusive lock on the row that is to be updated
- When the control is moved to the next updatable row, the lock is released
REPEATABLE READ:
- RR is a page level locking
- Acquires an exclusive lock on the entire page which is the source of row availability
- When the control is moved to the next updatable page the lock is released
View answer
Workspace
Report Error
Discuss