Is BETWEEN inclusive of the range values specifi

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

(Continued from previous question...)

Is BETWEEN inclusive of the range values specified?

Yes

(Continued on next question...)

Other Job Interview Questions

• What is the basic differnce between a join and a union?
• What is a Cartesian product?
• What is the basic differnce between a join and a union?
• Describe a primary key?
• We have a table with a CHARACTER data type field
• What is meant by null?
• What is the syntax for a CREATE TABLE statement ?
• What is a NULL value? What are the pros and cons of using NULLS ?
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• What do you accomplish by GROUP BY ... HAVING clause ?
• More...