Database Fundamentals — Question 134

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?

Answer options

• A. THAT
• B. WHERE
• C. GROUP BY
• D. HAVING

Correct answer: B

Explanation

The correct answer is B, WHERE, as this clause is used to specify the condition that identifies which records should be updated. The other options, A (THAT), C (GROUP BY), and D (HAVING), are not applicable in this context since they do not serve the purpose of filtering records for an UPDATE operation.