View the Exhibit and analyze the CREATE TABLE statements used to create the ITEMS and ORDERS tables.
The ITEMS table has 50 rows and ORDERS table has 500 rows. Because you decide to not deal
with the item code 188 in future, you execute the following command to remove the item:
SQL> DELETE FROM items WHERE item_code=188;
What is the effect of this command?
A.
The command fails with integrity violation error.
B.
The row containing the value 188 corresponding to the ITEM_CODE column is deleted from the
ITEMS table, and the dependent rows in the ORDERS table are populated with NULL values in
their ITEM_CODE columns.
C.
The row containing the value 188 corresponding to the ITEM_CODE column is deleted from the
ITEMS table, and the foreign key constraint is disabled in the ORDERS table.
D.
The row containing the value 188 corresponding to the ITEM_CODE column is deleted from the
ITEMS table, and the dependent rows in the ORDERS table are also deleted automatically.