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)- A5% (1)
- B81% (17)
- C10% (2)
- D5% (1)
Community Discussion
No community discussion yet for this question.