What are the two levels of isolation and what is the major difference

1.	What are the two levels of isolation and what is the major difference between the 2 levels?
Answer» The two levels of isolation are CURSOR Stability (CS) and Repeatable Read (RR). The major difference between these 2 levels is that the Cursor Stability (CS) RELEASES the lock on a page after the USE whereas the Repeatable Read (RR) retains all the locks till the END of a transaction.

Discussion