What are the isolation levals possible ?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What are the isolation levals possible ?

CS: Cursor Stability
RR: Repeatable Read

(Continued on next question...)

Other Interview Questions

• What are some SQL aggregates and other built-in functions?
• Usually, which is more important for DB2 system performance
• What is meant by repeatable read?
• Can you define an Index if the table size less than 10 PAGES?
• Under what circumstances will DB2 allow an SQL satement ...
• How many clustering indexes can be defined for a table?
• When does the SQL statement gets executed when you use cursor in the application programming ?
• What does DSNDB07 database do?
• Once you create a view, where would information about the view be stored?
• What is the purpose of the DSNC transaction?
• More...