Using Conditional Retrieval › Review

Review

Choose the correct answers for the questions below. More than one answer can apply for each question.

1. The clause that allows the user to specify a search condition that filters the rows to be selected is:
   • a. The WHERE clause
   • b. The FROM clause
   • c. The SELECT clause
   • d. The AS clause
2. What are the components of the WHERE clause?
   • a. The keyword FROM
   • b. The keyword WHERE
   • c. A search condition
   • d. A table name
3. You can compare a character column to a:
   • a. FROM clause
   • b. Mask
   • c. WHERE clause
   • d. Table name
4. Masks are used with:
   • a. The IN predicate
   • b. The BETWEEN predicate
   • c. The LIKE predicate
   • d. The FROM clause
5. Which of the following are mask characters?
   • a. #
   • b. _
   • c. *
   • d. %
6. The IS NULL predicate causes:
   • a. Retrieval of rows where a column contains the value zero
   • b. Retrieval of rows where a column contains no value
   • c. No retrieval of rows
   • d. No retrieval of rows where all columns contain zero
7. Parentheses are used to:
   • a. Set up the sequence of arithmetic evaluation
   • b. Set up the sequence of evaluation of AND and OR with multiple predicates
   • c. Set off table names
   • d. Set up alternate headings

To check your answers, see Review Answers for Chapter 4.