When one binds a PACKAGE of a plan what packag

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

(Continued from previous question...)

When one binds a PACKAGE of a plan what package information is stored and where it is stored?

The access path information for the PACKAGE is stored as skeleton package tables in the SPT01 table.

(Continued on next question...)

Other Job Interview Questions

• What is the cascade rule and how does it relate to deletions made with a subselect ?
• What is the database descriptor?
• What is the difference between join and union ?
• What is isolation level?
• What do you mean by NOT NULL WITH DEFUALT? When will you use it ?
• How do you achieve record level locking in DB2 versions when record level locking is not allowed?
• What are PACKAGES?
• On the create tablespace, what does the CLOSE parameter do?
• What is REORG? When is it used
• What is the best lock size that you could use when you create a tablespace?
• More...