Sql Chapter 8 Review Questions Answers

Chapter 8 Solutions

Review Questions

1. Which clause of a SQL query is used to restrict the number of rows returned?

WHERE clause

2. Which clause of a SQL query displays the results in a specific sequence?

ORDER BY clause

3. Which operator can you use to find any books with a retail price of at least $24.00?

>=

4. Which operator should you use to find NULL values?

IS NULL

5. The IN comparison operator is similar to which logical operator?

OR

6. When should single quotation marks be used in the WHERE clause?

When nonnumeric data is specified in the condition

7. What's the effect of using the NOT operator in a WHERE clause?

Reverses the meaning of the search condition and searches for records that don't match the

condition.

8. When should a percent sign (%) be used with the LIKE operator?

To represent more than one character

9. When should an underscore symbol ( _ ) be used with the LIKE operator?

To represent exactly one character in a specific position

10. Because % is a wildcard character, how can the LIKE operator search for a literal percent sign (%)

in a character string?

Use the ESCAPE option to include an escape character in the search pattern to indicate the

value should be treated literally.