What is a collection?

DB2 ( IBM Database 2 ) 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 Interview Questions

• What is the syntax of SELECT statement when embedded in a COBOL program ?
• What is SKELETON cursor table (SKCT?
• When do you specify the isolation level? How ?
• How many sub queries can you combine together?
• What is the SQL Communicaions Area and what are some of its key fields?
• What information can you find in SYSIBM.SYSLINKS table?
• What is a correlated sub query?
• Where are plans stored ?
• What is the STOSPACE Utility used for ?
• How do you achieve record level locking in DB2 versions when record level locking is not allowed?
• More...