CIS276 – Test Week 10 due Sun 06-16-2013

Name: ______________________________

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.)

How many columns can be returned by a single-row subquery? (3 points)
ANSWER: __________________

A single-row subquery can be used in which clauses of the outer query?
(3 points)
ANSWER: __________________ (hint: 4 clauses)

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

Can a GROUP BY be included in a single-row subquery? (3 points)
ANSWER: __________________

When should a single-row operator be included in a HAVING clause of the outer query? (3 points)
ANSWER: __________________

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

What type of comparison operators can be used with a multiple-row subquery? (4 points)
ANSWER: __________________

If the “greater than” comparison operator is used with a multiple-row subquery, what type of result will be returned? (4 points)
ANSWER: __________________

Which of the variations of the ANY operator is the same as using the IN comparison operator? (4 points)
ANSWER: __________________

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

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

Which group function will include NULL values? (4 points)
ANSWER: __________________

When is the GROUP BY clause used? (4 points)
ANSWER: __________________

When is it appropriate to use the NATURAL JOIN keywords? (4 points)
ANSWER: __________________

CIS276 – Test week 10 due Sun 06/16/13 Page 1 of 2

? (4 points)
ANSWER:…