Oracle
1Z0-007 · Question #146
1Z0-007 Question #146: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #146. The question stem and answer options stay visible for context.
Question
Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5. GROUP BY dept_id) b 6. WHERE a.dept_id = b.dept_id 7. AND a.sal < b.maxsal; What is the result of the statement?
Options
- AThe statement produces an error at line 1.
- BThe statement produces an error at line 3.
- CThe statement produces an error at line 6.
- DThe statement returns the employee name, salary, department ID, and maximum salary earned in
- EThe statement returns the employee name, salary, department ID, and maximum salary earned in
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 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.