View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY tables. The EMPLOYEES table maintains the most recent information regarding salary, department, and job for all the employees. The JOB_HISTORY table maintains the record for all the job changes for the employees. You want to delete all the records from the JOB_HISTORY table that are repeated in the EMPLOYEES table.
Which two SQL statements can you execute to accomplish the task? (Choose two.)
A. DELETEFROM job_history jWHERE employee_id =(SELECT employee_idFROM employees eWHERE j.employee_id = e.employee_id)AND job_id = (SELECT job_idFROM employees eWHERE j.job_id = e.job_id);
B. DELETEFROM job_history jWHERE (employee_id, job_id) = ALL(SELECT employee_id, job_idFROM employees eWHERE j.employee_id = e.employee_id and j.job_id = e.job_id)
C. DELETEFROM job_history jWHERE employee_id =(SELECT employee_idFROM employees eWHERE j.employee_id = e.employee_id and j.job_id = e.job_id)
D. DELETEFROM job_history jWHERE (employee_id, job_id) =(SELECT employee_id, job_idFROM employees eWHERE j.employee_id = e.employee_id and j.job_id = e.job_id)
|
Download Printable PDF. VALID exam to help you PASS. |
 |
C,D
CD