Microsoft
98-364 · Question #135
A database contains two tables named Customer and Order. You execute the following statement: - DELETE FROM Order - WHERE CustomerID = 209 What is the result?
The correct answer is C. All orders for CustomerID 209 are deleted from the Order table. See the full explanation below for the reasoning.
Question
A database contains two tables named Customer and Order. You execute the following statement:
- DELETE FROM Order
- WHERE CustomerID = 209
What is the result?
Options
- AThe first order for CustomerID 209 is deleted from the Order table.
- BAll orders for CustomerID 209 are deleted from the Order table,
- CAll orders for CustomerID 209 are deleted from the Order table.
- DCustomerID 209 is deleted from the Customer table.
How the community answered
(44 responses)- A2% (1)
- B9% (4)
- C84% (37)
- D5% (2)
Community Discussion
No community discussion yet for this question.