Question

You need to update both the DEPARTMENT_ID and LOCATION_ID columns in the EMPLOYEES table using one UPDATE statement. Which clause should you include in the UPDATE statement to update multiple columns?

Answer 1

The correct answer for the following question is the Set Clause.

Step-by-step explanation:

Set clause : Set or restore the value by repairing or replacing any part earlier to the loss.

This clause will help you to update multiple column in a table by using a single UPDATE statement in a prior notice or earlier to the loss.

Example of set clause :

UPDATE Employees

SET EName = 'Justin Bieber', City= 'America'

WHERE EID = 16;