📚 Practice Mode

Oracle PL/SQL Programming Quiz

Learn at your own pace with hints and detailed explanations

1 / 20

Multiple Choice

The following statement will raise an exception on which line? select dept_name, avg(all salary) ,count() “number of employees” from emp , dept where deptno = dept_no and count() > 5 group by dept_name order by 2 desc;

select dept_name, avg(all salary), count(*) “number of employees"
where deptno = dept_no
and count(*) > 5
group by dept_name
order by 2 desc;