Week #13 Quiz - Week#13Quiz...

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

1. A subquery is required when the condition for the inner query is based upon an unknown. A) True B) False Submitted by Sultana,Nahida on 4/23/2015 7:16:48 PM Points Awarded 9.00 Points Missed 1.00 Percentage 90.0% Points Earned: 1.0/1.0
2. The EXISTS operator must be listed ____. Points Earned: 1.0/1.0
3. A multiple­row subquery can be nested in a HAVING clause. Points Earned: 1.0/1.0
4. A(n) GROUP BY clause can be used in a subquery. Correct Answer(s): True Points Earned: 0.0/1.0
5. Which of the following subqueries returns more than one row of results to the outer query? A) multiple­column subquery
B) single­row subquery C) multiple­row subquery D) correlated subquery 6. A(n) ____ subquery is one that can return several rows of results.
7.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture