Explain different isolation levels?

Answers were Sorted based on User's Feedback



Explain different isolation levels?..

Answer / 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

Explain different isolation levels?..

Answer / 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

Explain different isolation levels?..

Answer / hari

Isolaton is the reduce the concurrency
Default 1)Read Commit
2)Read Uncommit
3)Repatable read
4) Serizable--

Is This Answer Correct ?    2 Yes 3 No

Explain different isolation levels?..

Answer / pavan singh

there are 5types of isolation level
1.ecoas
2.read commited
3.read uncommited
4.repetable read
5.synchronized

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What is an index in sql?

0 Answers  


What do you understand by mirroring?

0 Answers  


What does the not null constraint do?

0 Answers  


How except clause is differs from not in clause?

0 Answers  


please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,






How does clustered and non clustered index work?

0 Answers  


What is user defined stored procedures?

0 Answers  


Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,


What is a collation?

0 Answers  


What have included columns when we talk about sql server indexing?

0 Answers  


What is the difference between getdate and sysdatetime?

0 Answers  


What is function of CUBE ?

0 Answers   HCL,


Categories