Oracle
1Z0-071 · Question #5
1Z0-071 Question #5: Real Exam Question with Answer & Explanation
The correct answer is B. DELETE orders. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. ORDER__ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option. Which DELETE statement would execute successfully?
Exhibit
Options
- ADELETE order_id
- BDELETE orders
- CDELETE
- DDELETE orders o, order_items i
Community Discussion
No community discussion yet for this question.