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

Question : 2 of 50

Marks: +1, -0

Which two statements are true regarding the SQL GROUP BY clause? (Choose two.)

You can use a column alias in the GROUP BY clause.
Using the WHERE clause after the GROUP BY clause excludes rows after creating groups.
The GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause.
Using the WHERE clause before the GROUP BY clause excludes rows before creating groups.
If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.

Go to Question:

Prev Question

Next Question