nerdexam
Microsoft

98-364 · Question #159

You have a table of products with fields for ProductID, Name, and Price. You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID. Which clause…

The correct answer is B. WHERE. See the full explanation below for the reasoning.

Question

You have a table of products with fields for ProductID, Name, and Price. You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID. Which clause should you use in your update statement?

Options

  • ATHAT
  • BWHERE
  • CGROUP BY
  • DHAVING

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    81% (17)
  • C
    10% (2)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice