Oracle
1Z0-071 · Question #125
View the Exhibit and examine the structure of the ORDERS table. You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101. Which query…
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 must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101. Which query would give you the desired result?
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
(35 responses)- A17% (6)
- B9% (3)
- C71% (25)
- D3% (1)
Community Discussion
No community discussion yet for this question.