Which of the following statements about the UPDATE command is incorrect?
A) The UPDATE clause identifies the table containing the record(s)to be changed.
B) The SET clause is used to identify the column(s)to be changed,and the new value(s)to be assigned to that column.
C) The mandatory WHERE clause identifies the specific row(s)to be changed by the UPDATE command.
D) The optional WHERE clause identifies the specific row(s)to be changed by the UPDATE command.

Question

Which of the following statements about the UPDATE command is incorrect?​
A) ​The UPDATE clause identifies the table containing the record(s)to be changed.
B) ​The SET clause is used to identify the column(s)to be changed,and the new value(s)to be assigned to that column.
C) ​The mandatory WHERE clause identifies the specific row(s)to be changed by the UPDATE command.
D) ​The optional WHERE clause identifies the specific row(s)to be changed by the UPDATE command.

Quizplus · Accepted Answer

The WHERE clause in an UPDATE command is optional, not mandatory. It is used to specify which rows should be updated. If the WHERE clause is omitted, all rows in the table will be updated.

Which of the Following Statements About the UPDATE Command Is