Oracle
1Z0-047 · Question #1
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?
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
(60 responses)- A3% (2)
- B12% (7)
- C82% (49)
- D3% (2)
Community Discussion
No community discussion yet for this question.