Question

The WHERE clause of the UPDATE command is used to specify exactly which rows should be changed. _________________________​

a. True
b. False

Answer 1

The WHERE clause in the UPDATE command is indeed used to specify which rows in a database table should be updated, making the statement true.

Step-by-step explanation:

The statement is true. The WHERE clause of the UPDATE command in SQL is used to specify exactly which rows should be changed. By using this clause, the UPDATE operation can be limited to rows that fulfill a certain condition, thereby preventing unintended modifications to other rows in the table. If the WHERE clause is omitted, all rows in the table would be updated.