What is a DBRM, PLAN?

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

(Continued from previous question...)

What is a DBRM, PLAN?

DBRM: Data Base Request Module, has the SQL statements extracted from the host language program by the pre-compiler.
PLAN: A result of the BIND process. It has the executable code for the SQL statements in the DBRM.

(Continued on next question...)

Other Job Interview Questions

• What is correlation names ?
• Compare a subselect to a join?
• What types of copies can be made with the COPY Utility?
• What information can you find in SYSIBM.SYSLINKS table?
• When would you prefer to use VARCHAR ?
• When do you specify the isolation level? How ?
• What is a recovery log?
• How many Buffer pools are there in DB2 and what are they ?
• I need to view the number of tables existing under one particular OWNER. Is it possible ? If so, please give the SQL query for this ?
• What is subquery ?
• More...