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

View the Exhibit and examine the structure of EMPLOYEES and JOB_IHISTORY 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_IHISTORY 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 =
(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);

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

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

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



Leave a Reply 0

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