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;

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