Oracle
1Z0-047 · Question #194
View the Exhibit and examine the structure of the ORDER_ITEMS table. You need to display the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table…
The correct answer is D. SELECT order_id. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the ORDER_ITEMS table. You need to display the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table. Which query would produce the desired output?
Exhibit
Options
- ASELECT order_id
- BSELECT order_id
- CSELECT order_id
- DSELECT order_id
How the community answered
(16 responses)- B6% (1)
- C13% (2)
- D81% (13)
Community Discussion
No community discussion yet for this question.