Which of the following update statements will change the salary and job title of employee Scott to
that of Adams?
Each correct answer represents a complete solution. Choose all that apply.
A.
UPDATE EMP
SET JOB=(SELECT JOB FROM EMP WHERE ENAME=’ADAMS’),
SAL=(SELECT SAL FROM EMP WHERE ENAME=’ADAMS’)
WHERE ENAME=’SCOTT’;
B.
UPDATE EMP
SET (SAL,JOB)=(SELECT SAL,JOB FROM EMP WHERE ENAME=’SCOTT’)
WHERE ENAME=’ADAMS’;
C.
UPDATE EMP
SET SAL=(SELECT SAL FROM EMP WHERE ENAME=’ADAMS’),
JOB=(SELECT JOB FROM EMP WHERE ENAME=’ADAMS’)
WHERE ENAME=’SCOTT’;
D.
UPDATE EMP
SET (SAL,JOB)=(SELECT SAL,JOB FROM EMP WHERE ENAME=’ADAMS’)
WHERE ENAME=’SCOTT’;