Explain different isolation levels?

Question Posted / guest

4 Answers
10915 Views
I also Faced
E-Mail Answers

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

Explain microsoft sql server functions?

0 Answers

what is hash nonclustered index

0 Answers

Why use “in” clause in sql server?

0 Answers

How to create stored procedures with parameters in ms sql server?

0 Answers

Where do you think the users names and passwords will be stored in sql server?

4 Answers BirlaSoft,

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers TCS,

What is pessimistic concurrency?

0 Answers

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers Perot Systems,

Can you explain the role of each service?

1 Answers

can you any body tell me the difference between candidate key and primary key

4 Answers

What happens when converting big values to integers?

0 Answers

What is proper subset of candidate key?

0 Answers

For more SQL Server Interview Questions Click Here