为自己加油

将员工号为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 ;