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.
Answer: C