Oracle
1Z0-047 · Question #249
View the Exhibit and examine the structure of the ORDERS table. You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the…
The correct answer is C. SELECT order_id, order_date FROM orders. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the ORDERS table. You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101 Which query would give you the desired output?
Exhibit
Options
- ASELECT order_id, order_date FROM orders
- BSELECT order_id, order_date FROM orders
- CSELECT order_id, order_date FROM orders
- DSELECT order_id, order_date FROM orders
How the community answered
(27 responses)- A11% (3)
- B4% (1)
- C70% (19)
- D15% (4)
Community Discussion
No community discussion yet for this question.