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 |
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance
What is Outter Join?
Security Question- SQL DBA exparts, need your help...
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
Which institute is best for SQL Server 2005 Training?
What does ss stand for sexually?
Do you think BCNF is better than 2NF & 3NF? Why?
What is truncate table?
what is the difference between delete,drop and truncate
What are the source of constraints?
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
How can I check that whether automatic statistic update is enabled or not?
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)