What is isolation level?

SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.
  • Interview Candidate
  • 1
  • 4792

Showing Answers 1 - 1 of 1 Answers

ramanatcs

  • Dec 24th, 2008
 

Isolation  Level determines the duration of the lock over a page.
3 level are there.

1. Cursor Stability : lock is retained when untill the cursor moves from one record in one page to the next record in another page. Provides WRITE Integrity.

2. Repeatable Read : Lock is retained untill the commit point. When you want to read same set of row without any updates go for this one. provides READ and WRITE Integrity.

3. Uncommitted Read : It is in Dataware housing applications.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions