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...


What is isolation level?

Answers were Sorted based on User's Feedback



What is isolation level?..

Answer / vignesh

DB2 Provides different levels of protection, To isolate data

1. UN COMMITTED READ
2. CURSOR STABILITY
3. READ STABILITY
4. REPEATABLE READ

Is This Answer Correct ?    2 Yes 0 No

What is isolation level?..

Answer / narasimharao

it specifies level of locking is calling isolation

Is This Answer Correct ?    2 Yes 0 No

What is isolation level?..

Answer / pandurangan

DB2 ensures concurrency through ISOLATION levels, which
determines how data that is accessed or modified by one
transaction is isolated from other transaction.

There are 4 levels of isolation

1) Repeatable Read - if a transaction scans 1000 rows to
retrieve 20 rows, lock is acquired and held on all 1000 rows
until the transaction is complete.

2) Read Stability - If 10 rows are retrieved then lock will
be on 10 rows only till the completion of transaction.

3) Cursor Stability - Only locks the row that is referenced
by a cursor that was declared and owned by the transaction.

4) Uncommitted Read - Its just like read, since you haven't
committed you can see others making changes to it while you
are still on it.

For more details go to http://db2guide.blogspot.ie/

Is This Answer Correct ?    0 Yes 1 No

What is isolation level?..

Answer / narasimharao

there are three types
1.cursor stability
2.rerepeatable read
3.uncommited read or dirty read

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

Are views updatable ?

4 Answers  


What is dbrm in db2 database?

0 Answers  


What is db2 optimizer?

0 Answers  


Before you give the explain statement, what are the prerogatives?

0 Answers  


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  


Discuss about db2 bind?

0 Answers  


How can you display the current date & current time ?

7 Answers   Cap Gemini,


What is an instance in db2?

0 Answers  


Name the different types of Table spaces.

5 Answers   IBM,


How to see the structure of db2 table??

4 Answers   IBM,


If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


Categories