When is the results table for the query in a DEC

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

(Continued from previous question...)

When is the results table for the query in a DECLARE CURSOR statement created ?

The results table for q query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement.

(Continued on next question...)

Other Job Interview Questions

• What is a cursor ?
• Usually, which is more important for DB2 system performance
• What is lock escalation?
• Explain the use of the WHERE clause?
• What is an asychronous write?
• Explain an outer join ?
• How do you insert a record with a nullable colunm?
• Give some example of statistics collected during RUNSTATS?
• How would you move a tablespace to a different DASD volume allocated to that tablespace?
• What information is held in SYSIBM.SYSCOPY?
• More...