Home » Interview » Technology

What is the difference between Cursor Stability and Repeatable Read isolation levels?

Correct 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

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion