A database contains two tables named Customer and Order. You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209 What is the result?
A.
The first order for CustomerID 209 is deleted from the Order table.
B.
All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted
from the Customer table.
C.
All orders for CustomerID 209 are deleted from the Order table.
D.
CustomerID 209 is deleted from the Customer table.
We know that the statement “DELETE FROM Order” will only affect the Order table. So B and D can’t be right.