Explain different isolation levels?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Does full backup break log chain?
Explain what is the main purpose of having conversation group?
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?
How do I list the available tables in a database I'm querying?
how can i lock the column in the table
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to modify the underlying query of an existing view?
What is a raid and what are different types of raid configurations?
What is a function? Give some example?
Can we return Data from 4(more than 1) tables in stored procedure?
What is an Index?