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

Question : 29 of 50

Marks: +1, -0

Examine the data in the ORD_ITEMS table:

Evaluate this query:

Which statement is true regarding the result?

It returns an error because the HAVING clause should be specified after the GROUP BY clause.
It returns an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.
It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.
It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

Go to Question:

Prev Question

Next Question