UR- Uncommitted Read:
It is good for accessing read-only tables and read-only queries.
No record Locking is done.
CS- Cursor Stability:
<> It is a default isolation level.
<> It locks or unlocks each row at a time.
<> It guarantees to return only data which was committed at the time of reading.
RS- Read Stability:
<> It releases Locks on rows that do not satisfy the query predicates.
<> It is used for result set stability or when the future actions on returned rows may be taken.
RR- Repeatable Read:
<> It allows the application to retrieve and operate on rows as many times as needed.
<> It locks the entire table.
Posted Date:- 2021-09-03 01:43:48