Millionaire Mode
Oracle PL/SQL Programming Quiz
Question 1 of 20
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;
Prize Money
15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000