Which two SQL statements can you execute to accomplish the task?

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.)

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.
DELETE FROM job_history j WHERE (employee_id, job_id) = (SELECT employee_id,
job_id FROM employees e WHERE j.employee_id = e.employee_id and j.job_id = e.job_id)

B.
DELETE FROM job_history j WHERE employee_id = (SELECT employee_id FROM
employees e WHERE j.employee_id = e.employee_id) AND job_id = (SELECT job_id
FROM employees e WHERE j.job_id = e.job_id);

C.
DELETE FROM job_history j WHERE (employee_id, job_id) = ALL (SELECT
employee_id, job_id FROM employees e WHERE j.employee_id = e.employee_id and
j.job_id = e.job_id)

D.
DELETE FROM job_history j WHERE employee_id = (SELECT employee_id FROM
employees e WHERE j.employee_id = e.employee_id and j.job_id = e.job_id)



Leave a Reply 0

Your email address will not be published. Required fields are marked *