Can you use MAX on a CHAR column?

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

(Continued from previous question...)

Can you use MAX on a CHAR column?

YES

(Continued on next question...)

Other Job Interview Questions

• What is meant by locking?
• What is UNION, UNION ALL?
• What is the use of VALUE function?
• Can you use MAX on a CHAR column?
• What keyword does an SQL SELECT statement use for a string search?
• What is a join?
• What is a results table?
• In the WHERE clause what is BETWEEN and IN?
• Compare a subselect to a join?
• Can one add columns to a table after it has been defined?
• More...