What is the difference between CS and RR isolati

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• What is a base table ?
• What is meant by the attachment facility?
• In terms of DB2 indexing, what is the root page ?
• In a DB2-CICS program which is acts as co-ordinator and which is participant?
• What is the difference between primary key and unique index?
• What is the Manimum number of characters that a tablename can have?
• How is a typical DB2 batch program executed?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• What is a DB2 access path?
• What does the RUNSTATS Utility do?
• More...