DBMS (SQL)

Casual Mode - Take your time!

1 / 15

✓

Correct

0

✗

Incorrect

0

★

Score

0%

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);

select count(ENAME) from EMP where DEPTNO=30 and COMM is NULL;
select count(ENAME) from EMP where DEPTNO=30 and COMM is not NULL;
select count(ENAME) from EMP where DEPTNO<30 and COMM is not NULL;
select count(ENAME) from EMP where DEPTNO=30 and COMM has not NULL value;
none of these