Reference no: EM13331130

Please provide answer for the following questions in the space provided for the question.
(Only answers provided in the given space will be checked for credit.)

1. How many columns can be returned by a single-row subquery
ANSWER: __________________

2. A single-row subquery can be used in which clauses of the outer query?

ANSWER: __________________ (hint: 4 clauses)

3. What type of comparison operators can be used with a single-row subquery?
ANSWER: __________________

4. Can a GROUP BY be included in a single-row subquery?
ANSWER: __________________

5. When should a single-row operator be included in a HAVING clause of the outer query?
ANSWER: __________________

6. A multiple-row subquery is most commonly used in which clauses of the outer
` ANSWER: __________________ (2 clauses)

7. What type of comparison operators can be used with a multiple-row subquery?
ANSWER: __________________

8. If the "greater than" comparison operator is used with a multiple-row subquery, what type of result will be returned?
ANSWER: __________________

9. Which of the variations of the ANY operator is the same as using the IN comparison operator?
ANSWER: __________________

10. Which group functions can be used on date values?
ANSWER: __________________ (hint: 3 answers)

11. Which group functions can only be used with numeric values?
ANSWER: __________________ (hint: 4 answers)

12. Which group function will include NULL values?
ANSWER: __________________

13. When is the GROUP BY clause used?
ANSWER: __________________

14. When is it appropriate to use the NATURAL JOIN keywords?
ANSWER: __________________