Oracle Exam 1Z0-071 Topic 14 Question 89 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 89
Topic #: 14

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?

ASELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

BSELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

CSELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

DSELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

ESELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

Show Suggested Answer

Suggested Answer: D, E

by Ezekiel at Apr 14, 2024, 06:17 AM

Limited Time Offer

25%

16 days ago

Hmm, this question seems a bit tricky. I'm not entirely sure which query will return the desired result, but I'll give it my best shot.

upvoted 0 times

...