A VARCHAR column REMARKS would be defined as fol

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

(Continued from previous question...)

A VARCHAR column REMARKS would be defined as follows:

10 REMARKS.
49 REMARKS-LEN PIC S9(4) USAGE COMP.
49 REMARKS-TEXT PIC X(1920).

(Continued on next question...)

Other Job Interview Questions

• What are PACKAGES ? –
• What is a clustering index ?
• When would you prefer to use VARCHAR?
• What is difference between 911 and 913 error code in DB2 ?
• Where is the output of EXPLAIN stored? –
• What happens when you say OPEN CURSOR?
• What is the COBOL picture clause of the following DB2 data types:
• How would you find out the total number of rows in a DB2 table?
• What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
• Give some example of statistics collected during RUNSTATS?
• More...