1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain different isolation levels?

Question Posted / guest

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 the disadvantage of SQL Loder?

1 Answers   TCS,

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

Explain having clause and where clause?

0 Answers  

Explain what is the function of sql server agent windows service?

0 Answers  




what are batch in sql server?

2 Answers   Satyam,

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

What xml support does the sql server extend?

0 Answers  

Can XML be used to access data?

2 Answers  

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories