Which clause specifies the new values in an UPDATE statement?

Which clause specifies the new values in an UPDATE statement?

• A. UPDATE
• B. MODIFY
• C. CHANGE
• D. SET

Answer: (D)

The SET clause is used to specify the new values in an UPDATE statement. It lists column = value expressions that determine what data will be written to each matching row. For example, UPDATE employees SET salary = salary * 1.1, title = 'Senior Engineer' WHERE id = 102 updates salary and title for the row with that id. The WHERE clause controls which rows are affected; without it, every row would be updated. The other terms shown aren’t used to assign new data in standard SQL: UPDATE starts the statement, while MODIFY and CHANGE are not the clause for updating data in this context (they appear in other, non-updating DDL situations in some dialects).

The SET clause is used to specify the new values in an UPDATE statement. It lists column = value expressions that determine what data will be written to each matching row. For example, UPDATE employees SET salary = salary * 1.1, title = 'Senior Engineer' WHERE id = 102 updates salary and title for the row with that id. The WHERE clause controls which rows are affected; without it, every row would be updated. The other terms shown aren’t used to assign new data in standard SQL: UPDATE starts the statement, while MODIFY and CHANGE are not the clause for updating data in this context (they appear in other, non-updating DDL situations in some dialects).