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

Does full backup break log chain?

0 Answers  


Explain what is the main purpose of having conversation group?

0 Answers  


How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,


What is sql server schema compare? How we can compare two database schemas?

0 Answers  


How do I list the available tables in a database I'm querying?

4 Answers  






how can i lock the column in the table

2 Answers   Accenture,


Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  


How to modify the underlying query of an existing view?

0 Answers  


What is a raid and what are different types of raid configurations?

0 Answers  


What is a function? Give some example?

3 Answers  


Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,


What is an Index?

3 Answers   Yardi Software,


Categories