Question

Which of the following clauses of the UPDATE command is optional? (Points : 2) UPDATE

SET
WHERE
FROM

Answer 1

FROM.

Step-by-step explanation:

UPDATE table

SET column=value,column1=value1,.....

WHERE condition;

In the UPDATE command given in the question FROM is optional because when using UPDATE we already mention the table name with update look at the syntax above.So there is no need to again mention the table name in FROM.All other three are required that is UPDATE,SET,WHERE.