将员工号为1007的员工薪水改为3500,职位改为Programmer,下列SQL语句正确的是（）

A. update emp set salary = 3500 and job = Programmer where empno = 1007 ;
B. update emp set salary = 3500 ,set job = Programmer where empno = 1007 ;
C. update emp salary = 3500 , job = Programmer where empno = 1007 ;
D. update emp set salary = 3500 , job = Programmer where empno = 1007 ;