The HAVING clause does which of the following ?

1. Acts EXACTLY like a WHERE clause.
2. Acts like a WHERE clause but is used for columns rather than groups.
3. Acts like a WHERE clause but is used for groups rather than rows.
4. Acts like a WHERE clause but is used for rows rather than columns.

Aggregate functions can be used in the select list or the …………… clause of a select statement. They cannot be used in a …………… clause.

1. Where, having
2. Having, where
3. Group by, having
4. Group by, where

Which clause is used with "aggregate functions" ?

1. GROUP BY
2. SELECT
3. WHERE
4. Both (1) and (3)

What is the meaning of "HAVING" clause in SELECT query ?

1. To filter out the summary groups
2. To filter out the column groups
3. To filter out the row and column values
4. None of the mentioned