Quiz for Chapter 12 (10 questions for 20 points) - Quiz for...

This preview shows page 1 - 2 out of 2 pages.

1. When a multiple-column subquery is used in the WHERE clause of the outer query, the column names listed on the left side of the comparison operator must be enclosed in single-quotation marks. A) True B) False 2. A multiple-column subquery cannot be nested in a WHERE clause. 3. The results of the subquery are passed to the inner query. 4. A subquery can only be nested in the WHERE or HAVING clause of the outer query. 5. The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery. A) IN B) >ANY C) D) >ALL 6. The following SQL statement contains which type of subquery? Points Awarded 16.00 Points Missed 4.00 Percentage 80.0% Points Earned: 2.0/2.0

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture