Which three options ensure that the statement will execute successfully?

examine the create table statements for the stores and sales tables.

You executed the following statement:

Which three options ensure that the statement will execute successfully?
A. Disable the primary key in the STORES table,
B. Use CASCADE keyword with DELETE statement.
C. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
D. Disable the FOREIGN KEY in SALES table and then delete the rows.
E. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

Download Printable PDF. VALID exam to help you PASS.