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: