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 to disable a login name in ms sql server?

750


Can the “if update (colname)” statement be used in a delete trigger?

749


How to create “dependant” parameter “make, model, year”

105


What is use of dbcc commands?

787


Where are sql server usernames and passwords stored in the sql server?

793






How to create a large table with random data for index testing in ms sql server?

738


What is #temp and @table variable in SQL server?

764


How will you decide the active and passive nodes?

794


Explain different types of locks in sql server.

775


Write SQL queries on Self Join and Inner Join.

798


Why do we use trigger?

710


What are page splits? : SQL Server Architecture

746


What are different replication agents and what's their purpose? : sql server replication

743


What is meant by datasource?

684


Can we use custom code in ssrs?

781