DBMS (SQL)

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

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

Select Your Answer:

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

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current