Which of the following statements can be used to increase in 10% the salary of all employees in
department D1?

A.
UPDATE employees WHERE dept = ‘D1’ SET salary = salary * 1.1

B.
UPDATE employees SET salary = (salary * 1.1)

C.
UPDATE employees SET salary = salary * 1.1 WHERE dept = ‘D1’

D.
UPDATE salary = salary * 1.1 ON TABLE employees WHERE dept = ‘D1’

Explanation: