1. Which of the following are examples of comparison operators used in the WHERE clause?
=, >, <, <=, >=, <>
between ___ and ___
in (..,..,.. )
like
is null
All of the above (*)
2. When using the “LIKE” operator, the % and _ symbols can be used to do a pattern-matching, wild card search. True or False?
True (*)
False
3. Which of the following WHERE clauses would not select the number 10?
WHERE hours BETWEEN 10 AND 20
WHERE hours <= 10 WHERE hours <>10 (*)
WHERE hours IN (8,9,10)
4. Which statement would select salaries that are greater than or equal to 2500 and less than or equal to 3500?
Choose two correct answers.
WHERE salary >= 2500 AND salary <= 3500 (*)
WHERE salary <=2500 AND salary >= 3500
WHERE salary BETWEEN 2500 AND 3500 (*)
WHERE salary BETWEEN 3500 AND 2500
