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 |
What is an index in sql?
What do you understand by mirroring?
What does the not null constraint do?
How except clause is differs from not in clause?
please tell me the query to get details of the employee having the second largest salary
How does clustered and non clustered index work?
What is user defined stored procedures?
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
What is a collation?
What have included columns when we talk about sql server indexing?
What is the difference between getdate and sysdatetime?
What is function of CUBE ?