Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How to use go command in "sqlcmd"?

0 Answers  

What is lock escalation and what is its purpose?

0 Answers  

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

Explain the truncate command? : SQL Server Architecture

0 Answers  

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

What are functions

3 Answers  

How do you persist objects, permissions in tempdb

1 Answers  

What is normalization of database?

0 Answers  

Explain atomicity?

0 Answers  

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

What are the types of table?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories