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?
A. Option A
B. Option B
C. Option C
D. Option D
C
Correct answer is C , the DELETE syntax is OK
C
correct answer c tested
Correct answer is B , the DELETE syntax is wrong in the other 3 options
In B, the subquery is trying to delete just the ORDER_ID which is invalid. It is similar to D except without the WHERE clause. In C it is missing FROM but it will work in the newer version of Oracle.
C