Oracle PL/SQL Programming Quiz
Casual Mode - Take your time!
1 / 20
Correct
0
Incorrect
0
Score
0%
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;