Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 50 of 50

Marks: +1, -0

Which three statements are true regarding the SQL WHERE and HAVING clauses?

The HAVING clause conditions can have aggregating functions.
The HAVING clause conditions can use aliases for the columns.
The WHERE and HAVING clauses cannot be used together in a SQL statement.
The WHERE clause is used to exclude rows before grouping data.
The HAVING clause is used to exclude one or more aggregated results after grouping data.

Go to Question:

Prev Question