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 |
Can an automatic recovery be initiated by a user?
How can windows applications connect to sql servers via odbc?
How can i Relate Tables in SSIS
How to list all dsn entries on your local machine using odbc_data_source()?
What are the types of subquery?
What is data file in computer?
How do we rollback the table data in SQL Server
Can primary key be null?
Can group functions be used in the order by clause in ms sql server?
How to end a stored procedure properly in ms sql server?
how can a database be repaired? : Sql server administration
What is resultset concur_updatable?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)