Oracle Database Foundations Associate (1Z0-006)

Access More Questions

A database administrator needs to change the job title for an employee with the ID 7839 to 'SENIOR MANAGER'. The table is named 'EMP' and the columns are 'JOB' and 'EMPNO'. Which SQL statement correctly performs this update?

MODIFY emp SET job = 'SENIOR MANAGER' WHERE empno = 7839; CHANGE emp.job TO 'SENIOR MANAGER' WHERE emp.empno = 7839; UPDATE emp SET job = 'SENIOR MANAGER' WHERE empno = 7839; UPDATE emp WHERE empno = 7839 SET job = 'SENIOR MANAGER';

Correct Answer:

UPDATE emp SET job = 'SENIOR MANAGER' WHERE empno = 7839;

Access more questions from this quiz

Continue to Oracle Database Foundations Associate (1Z0-006) for more practice questions and the full quiz experience.

Access More Questions