📚 Practice Mode

DBMS (SQL)

Learn at your own pace with hints and detailed explanations

1 / 15
Multiple Choice

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
Change Mode