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

Solution for Test: Quiz: Introduction to The Oracle Academy

Solution for Test: Quiz: Data vs Information