Exam 1z0-082 topic 1 question 95 discussion

A E because 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.

A and E (max function gives only one output in st.1 / when group by order_id is used, max function is used for every order_id

A , E are the correct statements. I've tested on this same sample schema.

Yes, A & E are correct answers. The followding demo is what I have tested on LiveSQL. CREATE TABLE order_items (order_id number, unit_price number, quantity number); INSERT INTO order_items VALUES (1, 234.35, 300); INSERT INTO order_items VALUES (2, 95.10, 20); INSERT INTO order_items VALUES (3, 150.75, 400); INSERT INTO order_items VALUES (4, 50.65, NULL); INSERT INTO order_items VALUES (5, 20.15, 150); INSERT INTO order_items VALUES (6, 80.50, 70); COMMIT; SELECT MAX(unit_price * quantity) "Maximum Order" FROM order_items; Maximum Order ------------------------- 70305 SELECT order_id, MAX(unit_price * quantity) "Maximum Order" FROM order_items GROUP BY order_id; ORDER_ID Maximum Order ---------------- ------------------------- 6 5635 1 70305 2 1902 4 - 5 3022.5 3 60300

A - Correct in all scenarios E - Correct if there is more than 1 row C - Correct if there is only one row which has either UNIT_PRICE or QUANTITY contains NULL

A, E seems ok

any body pass this exam ? Please suggest