Oracle Database 12c SQL 1z0-071 Question # 38 Topic 4 Discussion

Oracle Database 12c SQL 1z0-071 Question # 38 Topic 4 Discussion

1z0-071 Exam Topic 4 Question 38 Discussion:
Question #: 38
Topic #: 4

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER

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 two statements are true?


A.

Statement 2 returns only one row of output.


B.

Both the statement given the same output.


C.

Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL,


D.

Statement 2 may return multiple rows of output.


E.

Statement 1 returns only one row of output.


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.