The column to be updated by the UPDATE command is specified in the ____ clause.
A) UPDATE
B) SET
C) WHERE
D) COL

Question

The column to be updated by the UPDATE command is specified in the ____ clause.​
A) ​UPDATE
B) ​SET
C) ​WHERE
D) ​COL

Quizplus · Accepted Answer

The SET clause in the UPDATE command is used to specify the column to be updated along with the new value. The WHERE clause is used to specify the conditions that must be met for the update to take place. The UPDATE keyword is the first word in the command and does not specify the column to be updated. There is no COL clause in SQL.

The Column to Be Updated by the UPDATE Command Is