Explain different isolation levels?

Answer Posted / swapna

An isolation level determines the degree of isolation of
data between concurrent transactions. The default SQL
Server isolation level is Read Committed.

Here are the other isolation levels (in the ascending order
of isolation): Read Uncommitted, Read Committed, Repeatable
Read, Serializable

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I uninstall sql server 2014?

592


How to provide login information for a new odbc dsn?

615


What is the difference between ‘having’ clause and a ‘where’ clause?

651


what is the sql equivaent of the dataset relation object ?

1659


What is the name of the Database which IBM mainframe uses?

639






How do I get to sql server configuration manager?

607


How can I get data from a database on another server?

583


Where to find ntwdblib.dll version 2000.80.194.0?

640


Explain optimistic and pessimistic concurrency?

628


Differentiate between truncate vs delete in mssql?

600


Explain partitioned view?

690


What do you mean by sql server agent?

631


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

648


What is normalization and what are the advantages of it?

599


How to execute stored procedure in select statement sql server?

618