What is the difference between CS and RR isolation levels ?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is the difference between CS and RR isolation levels ?

CS: Release the lock on a page after use
RR: Retains all locks acquired till end of transaction

(Continued on next question...)

Other Interview Questions

• What is the function of buffer manager ?
• How could one combine a set of incremental image copies into a single copy?
• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
• What is SKELETON cursor table (SKCT?
• What can the Locate option of the Repair Utility accomplish?
• Which DB2 command is used to retireve environmental information?
• Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• What is a base table ?
• When is the access path determined for dynamic SQL?
• More...