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 j.job_id = e.job_id)

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

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 job _id = (SELECT job _id
FROM employees e WHERE j.job_id = e.job_id);



Leave a Reply 1

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


ming

ming

Looks like C is also correct.