In the WHERE clause what is BETWEEN and IN?

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

(Continued from previous question...)

In the WHERE clause what is BETWEEN and IN?

BETWEEN supplies a range of values while IN supplies a list of values.

(Continued on next question...)

Other Job Interview Questions

• What is an index key?
• What is the difference between static and dynamic SQL?
• In the WHERE clause what is BETWEEN and IN?
• What are the column name qualifiers?
• Why SELECT * is not preferred in embedded SQL programs ?
• Why SELECT * is not preferred in embedded SQL programs ?
• After a table is defined, can columns be removed ?
• Describe the elements of the SELECT query syntax?
• What are foreign keys?
• When is it necessary to create a table index?
• More...