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

What are the hotfixes and patches in sql server?

547


How to round a numeric value to a specific precision?

573


What are tables in sql server?

535


What is the filtered index?

563


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

719






Explain the different index configurations a table can have?

509


What is the difference between Stored Procedures and triggers?

575


What are the indexes in sql server?

503


What is the new security features added in sql server 2016? : sql server security

619


What are the requirements for sql server 2016?

536


What is merge?

572


How to automatically create a log when an exception is being received into SQL Server?

741


What is ms sql server index?

565


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

497


What are the new scripting capabilities of ssms? : sql server management studio

558