What are PACKAGES?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What are PACKAGES?

They contain executable code for SQL statements for one DBRM.

(Continued on next question...)

Other Interview Questions

• What is REORG? When is it used
• Which DB2 command is used to retireve environmental information?
• What does DML stand for and what are some examples of it?
• How does DB2 determine what lock-size to use?
• How do you insert a record with a nullable colunm?
• What is the syntax required for the creation of a cursor ?
• What are some SQL aggregates and other built-in functions?
• an I alter a table when other user is selecting some columns ...
• How would you move a tablespace to a different DASD volume allocated to that tablespace?
• How many buffer pools are available in DB2
• More...