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

Question : 8 of 50

Marks: +1, -0

View the Exhibit and examine the details of the ORDER_ITEMS table

Evaluate the following SQL statements:
Statement 1:

SELECT MAX(unit_price*quantity) “Maximum Order" 
 FROM order_items;

Statement 2:

SELECT MAX(unit_price*quantity) “Maximum Order” 
 FROM order_items 
 GROUP BY order_id;

Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

Statement 2 would return multiple rows of output.
Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.
Statement 1 would not return give the same output.
Both the statements would give the same output.
Statement 1 would return only one row of output.

Go to Question:

Prev Question

Next Question