Oracle
1Z0-047 · Question #57
View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table. Which…
The correct answer is A. DELETE C. DELETE FROM order_items i. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table. Which DELETE statements are valid? (Choose all that apply.)
Exhibit
Options
- ADELETE
- BDELETE *
- CDELETE FROM order_items i
- DDELETE
How the community answered
(26 responses)- A77% (20)
- B15% (4)
- D8% (2)
Community Discussion
No community discussion yet for this question.
