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 a correlated sub-query? : Sql server database administration

0 Answers  


What is entity data services?

0 Answers  


What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  


How to create dbo table in sql server?

0 Answers  


write the query for taking database restore in sql?

2 Answers  






What is model database in sql server?

0 Answers  


How to create a view using data from another view?

0 Answers  


What do you understand by a stored procedure?

0 Answers  


difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,


What is data compression?

0 Answers  


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  


Categories