What is the difference between CS and RR isolation levels?



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

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


What is a DB2 catalog?

2 Answers  


How do you check for a null value in a db2 column?

2 Answers  


What will the COMMIT accomplish?

5 Answers  


Can SQL statements/queries be included in a copybook?

2 Answers  






Which isolation level provides highest data integrity?

0 Answers  


My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,


How can you display the current date & current time ?

1 Answers   Cap Gemini,


What will the DB2 optimizer do?

2 Answers  


What is load utility in db2?

0 Answers  


What is an inner join, and an outer join ?

1 Answers   CTA,


What is the difference between static and dynamic SQL?

1 Answers  


Categories