Millionaire Mode

DBMS (SQL)

Question 1 of 15

Select a query to display the number of employees who can earn commission in department number 30.

Consider the following relation schema:
 EMP(ENAME,EMPNO,SAL,COMM,DEPTNO,JOB,MGR,HIREDATE);

  1. select count(ENAME) from EMP where DEPTNO=30 and COMM is NULL;
  2. select count(ENAME) from EMP where DEPTNO=30 and COMM is not NULL;
  3. select count(ENAME) from EMP where DEPTNO<30 and COMM is not NULL;
  4. select count(ENAME) from EMP where DEPTNO=30 and COMM has not NULL value;
  5. none of these

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