Oracle
1Z0-071 · Question #210
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 B. DELETE D. DELETE. 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 two DELETE statements are valid (Choose two.)
Exhibit
Options
- ADELETE
- BDELETE
- CDELETE FROM order_items i
- DDELETE
How the community answered
(25 responses)- A20% (5)
- B72% (18)
- C8% (2)
Community Discussion
No community discussion yet for this question.
