Which two statements are true about WHERE and HAVING clauses? (Choose two.)
A.
A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
B.
A HAVING clause CANNOT be used in subqueries.
C.
A WHERE clause can be used to restrict both rows and groups.
D.
A HAVING clause can be used to restrict both rows and groups.
E.
A WHERE clause can be used to restrict rows only.
F.
A HAVING clause can be used to restrict groups only.
Explanation:
:
B: WHERE clause cannot be use to restrict groups
WHERE clause cannot be use when there is group functions.
D: A HAVING clause can only e used to restrict GROUPS.
Note: HAVING clause to specify which groups are to be displayed and thus further restrict the
groups on
the basis of aggregate information. The Oracle server performs the following steps when you use
the Having clause
1. rows are grouped
2. the group function is applied to the group
3. the group that match the criteria in the Having clause are displayed.