Oracle
1Z0-071 · Question #119
View the Exhibit and examine the structure of the ORDER_ITEMS table. You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table. Which…
The correct answer is A. 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 must select 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 result?
Exhibit
Options
- ASELECT order_id
- BSELECT order_id
- CSELECT order_id
- DSELECT order_id
How the community answered
(33 responses)- A79% (26)
- B3% (1)
- C12% (4)
- D6% (2)
Community Discussion
No community discussion yet for this question.