1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is the difference between CS and RR isolation levels?

Question Posted / guest


What is the difference between CS and RR isolation levels?..

Answer / s

CS - page or row locks are released as soon as the cursor
is moved to another row or page.

RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is an inner join, and an outer join ?

1 Answers   CTA,

Who uses db2?

0 Answers  

What is the meaning of -805 SQL return code?

3 Answers  

What is phantom read in db2?

0 Answers  

what is the soft code for deadlock ?

2 Answers   Logica CMG,




Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

What is alias in db2?

0 Answers  

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

Mention data types used in db2 ?

0 Answers  

Define predicate?

0 Answers  

how to check the table is empty or not?

3 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories