What is the result?

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.

View Answer

Answer: C