Oracle
1Z0-147 · Question #28
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…
The correct answer is C. A NULL value is returned from the subquery. See the full explanation below for the reasoning.
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.
How the community answered
(20 responses)- A15% (3)
- B5% (1)
- C75% (15)
- D5% (1)
Community Discussion
No community discussion yet for this question.