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

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 =
(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 2

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


Nick

Nick

C is wrong, B and D is right

Nick

Nick

Sorry, C D right