Oracle
1Z0-147 · Question #28
1Z0-147 Question #28: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #28. The question stem and answer options stay visible for context.
Question
Mr. King is the president of a company. Five managers report to him. All other employees report to these managers. Examine the code:
SELECT employee_ename
FROM emp employee
WHERE employee.empno NOT IN
(SELECT manager.mgr
FROM emp manager);
The above statement returns no rows selected. as the result. Why?
Options
- AAll employees have a manager.
- BNone of the employees has a manager.
- CA NULL value is returned from the subquery.
- DNOT IN operator is not allowed in subqueries.
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.