Explain different isolation levels?

Answer Posted / juliet

isolation is a property that defines how/when the changes
made by one operation become visible to other concurrent
operations

Different isolation levels are:
Repeatable Read
Read Stability
Cursor Stability
Un commited Read

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic functions for master, msdb, model, tempdb and resource databases?

656


Tell me what is the stuff and how does it differ from the replace function?

634


What is query processing?

623


How will you go about resolving deadlocks?

621


What is the purpose of the model database?

671






explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

547


What is the default port for SQL Server over a firewall?

686


Equi join and non equi join is possible with sql server?

575


What is the difference between substr and charindex in the sql server?

584


What do you mean by SQL injection attack?

717


What is a unique index?

605


What is change data capture (cdc) in sql server 2008?

662


Is it possible to update the views? If yes, how, if not, why?

625


Tell me about the approaches which you used to counter the DI problems.

868


What is merge replication?

776