Microsoft Exam Questions

Which clause should you use in your update statement?

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?

A.
THAT

B.
WHERE

C.
GROUP BY

D.
HAVING