ATTEMPT TO REMOVE EVERY ROW IN THE TABLE BY OMITTING A WHERE CLAUSE

3. Attempt to remove every row in the table by omitting a WHERE clause:

P AR T II

delete from products;

This will fail, due to a constraint violation because there are child records

in the ORDER_ITEMS table that reference PRODUCT_ID values in the

PRODUCTS table via the foreign key constraint FK_PRODUCT_ID.