What is a collection?

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

(Continued from previous question...)

What is a collection?

A user defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

(Continued on next question...)

Other Job Interview Questions

• What is ACQUIRE/RELEASE in BIND?
• What is the difference between TYPE 1 index and TYPE 2 index?
• What information is used as input to the bind process?
• How many Buffer pools are there in DB2 and what are they ?
• How would one remove old reorg information from the DB2 catalog?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What is referential integrity ?
• When is the skeleton cursor table created?
• B37 abend during SPUFI
• What are the three lock types?
• More...