database:

1.

2.

3.

4.

5.

The clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement. Select one: a. IN b. FROM C. ORDER BY d. HAVING The special operator used to check whether a subquery returns any rows is Select one: a. IN O b. LIKE O c. BETWEEN d. EXISTS The SQL aggregate function that gives the highest value within a column is Select one: a. SUM O b. b. COUNT C. MAX d. MIN The SQL aggregate function that gives the number of rows containing non-null values for a given column is Select one: O a. SUM Ob. MIN O c. MAX d. COUNT When using an equality (=) or inequality (, etc.) operator for a subquery, what type of value must the subquery return? Select one: a. single value O b. list of values C. no value d. many values