Oracle Database SQL — Question 51

The ORDERS table has a primary key constraint on the ORDER_ID column.

The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.

The constraint is defined with ON DELETE CASCADE.

There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000.

Which three DELETE statements execute successfully? (Choose three.)

Answer options

• A. DELETE order_id FROM orders WHERE order_total < 1000;
• B. DELETE orders WHERE order_total < 1000
• C. DELETE * FROM orders WHERE order_total < 1000;
• D. DELETE FROM orders;
• E. DELETE FROM orders WHERE order_total < 1000;

Correct answer: B, D, E

Explanation

Option B successfully deletes rows based on the specified condition. Option D deletes all rows from the ORDERS table, which is valid. Option E also deletes rows based on the ORDER_TOTAL condition. Options A and C are incorrect due to the incorrect syntax for DELETE statements, as they do not conform to the standard SQL DELETE commands.