Exit C2090-733 DB2 9 Application Developer
Question 1 of 5
0% complete
Q1 Single choice

The table EMP was created with the following statement: CREATE TABLE emp (empno INT NOT NULL, project CHAR(10))

Which of the following statements will return a list of employees who are not assigned to any project?

  • A

    SELECT empno FROM emp WHERE project = NULL

  • B

    SELECT empno FROM emp WHERE project IS NULL

  • C

    SELECT empno FROM emp WHERE project IS ZERO

  • D

    SELECT empno FROM emp WHERE project IS NULLABLE

Previous Next