What keyword does an SQL SELECT statement use fo

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

(Continued from previous question...)

What keyword does an SQL SELECT statement use for a string search?

The LIKE keyword allows for string searches. The % sign is used as a wildcard.

(Continued on next question...)

Other Job Interview Questions

• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• What is normalization and what are the five normal forms?
• Is BETWEEN inclusive of the range values specified?
• What is an image copy?
• In the WHERE clause what is BETWEEN and IN?
• When can an insert of a new primary key value threaten referntial integrity?
• What is a join?
• Can you use MAX on a CHAR column?
• After a table is defined, can columns be removed ?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• More...