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

Do you know what are acid properties of transaction?

0 Answers  

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

What are security principals used in sql server 2005?

0 Answers  

What security features are available for stored procedure?

0 Answers  

What is sql collation?

0 Answers  

Explain the properties of subqueries in sql server?

0 Answers  

Explain rdbms?

0 Answers  

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

What is xdr?

0 Answers  

What is the difference between functions and stored procedures?

0 Answers   Accenture,

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories