DBI202Xuất hiện trong 1 đề thi
Which SQL statements will correctly update the salary of all employees by 10% where job title is 'Manager'?
Các lựa chọn
AUPDATE Employees SET salary = salary * 1.1 WHERE job = 'Manager';
BUPDATE Employees WHERE job = 'Manager' SET salary = salary * 1.1;
CUPDATE Employees SET salary *= 1.1 WHERE job = 'Manager';
DMODIFY Employees SET salary = salary + salary*0.1 WHERE job = 'Manager';