Oracle Exam 1Z0-082 Topic 5 Question 6 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 6
Topic #: 5

[All 1Z0-082 Questions]

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

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

AStatement 1 returns only one row of output.

BStatement 2 returns only one row of output.

CBoth statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

DBoth the statements give the same output.

EStatement 2 may return multiple rows of output.

Show Suggested Answer

Suggested Answer: A, E

https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj27781.html

The Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in data type. You can therefore call methods that evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.

by Lawrence at May 09, 2022, 04:47 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!