What is DB2 ( IBM Database 2 )?

DB2 ( IBM Database 2 ) Interview Questions

What is DB2 ( IBM Database 2 )?

DB2 is subsystem of the MVS operating system. It is a Database Management System ( DBMS ) for that operating system.

(Continued on next question...)

Other Interview Questions

• What are some characteristics of columns that benefit from indexes ?
• Which command is issued to establish the Boot Strap Data Set after an I/O failure?
• What is a Cartesian product?
• What is IMAGECOPY
• What is subquery ?
• What is the Manimum number of volumes that can be added to a STOGROUP?
• In terms of DB2 indexing, what is the root page ?
• What is a Resource Control Table (RCT)? Describe its characteristics.
• What is EXPLAIN?
• What is the syntax of SELECT statement when embedded in a COBOL program ?
• More...