When would you prefer to use VARCHAR?

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

(Continued from previous question...)

When would you prefer to use VARCHAR?

When a column which contains long text, e.g. remarks, notes, may have in most cases less than 50% of the maximum length.

(Continued on next question...)

Other Job Interview Questions

• How many clustering indexes can be defined for a table?
• What is the result of this query if no rows are selected:
• What is the restriction on using UNION in embedded SQL?
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• Name some fields from SQLCA.
• What are simple, segmented and partitioned table spaces ?
• What are the contents of a DCLGEN?
• When would you prefer to use VARCHAR?
• What is REORG? When is it used?
• EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
• More...