What are the disadvantages of using VARCHAR?

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

(Continued from previous question...)

What are the disadvantages of using VARCHAR?

1. Can lead to high space utilization if most of the values are close to maximum.
2. Positioning of VARCHAR column has to be done carefully as it has performance implications.
3. Relocation of rows to different pages can lead to more I/Os on retrieval.

(Continued on next question...)

Other Job Interview Questions

• How do you specify and use a cursor in a COBOL program? –
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?
• What is lock escalation?
• When you COMMIT, is the cursor closed? - drona questions–
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• How does DB2 determine what lock-size to use?
• How is a typical DB2 batch pgm executed ?
• What is a synonym ?
• When do you use the IMAGECOPY? – –
• More...