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 |
Do you know what are different types of replication in sql server?
How to use the inserted and deleted pseudo tables?
Mention the differences between substr and charindex in sql server.
What is an inner join?
How to Insert multiple rows with a single insert statement?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is a table called, if it does not have neither Cluster nor Non-cluster Index?
How to create a view with data from multiple tables?
Define self join in sql server joins?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is an identity column in insert statements?
What is onf in normalization form?