What are the levels of isolation available with

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are the levels of isolation available with DB2V4?

CS RR UR (added new for DB2V4 which stands for uncommitted read which allows to retrieve records from the space which has exclusive locks also but data integrity will be affected if this option is used ) The best available option for integrity and data concurrency is CS.

(Continued on next question...)

Other Job Interview Questions

• If I have a view which is a join of two or more tables, can this view be updatable?
• What is a data type?
• 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?
• How would you move a tablespace to a different DASD volume allocated to that tablespace?
• What is the syntax required for the creation of a cursor ?
• What is an asychronous write?
• What is the cascade rule and how does it relate to deletions made with a subselect ?
• What DB2 Catalog column tell you when an index needs table reorganized?
• What is the Manimum number of characters that a tablename can have?
• More...