nerdexam
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)
  • A
    2% (1)
  • B
    9% (4)
  • C
    84% (37)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice