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?

Question

Accepted Answer

B. DELETE orders

Answer

A. DELETE order_id

Answer

C. DELETE

Answer

D. DELETE orders o, order_items i

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…

Question

Exhibit

Options

How the community answered

Community Discussion