Given the following CREATE TABLE statement:

CREATE TABLE EMPLOYEE
(EMPNO CHAR(3) NOT NULL,
FIRSTNAME CHAR(20) NOT NULL,
MIDINIT CHAR(1),
LASTNAME CHAR(20) NOT NULL,
SALARY DECIMAL(10, 2))
Which of the following will retrieve the rows that have a missing value in the MIDINIT column?

A.
SELECT * FROM employee WHEREmidinit = ‘ ‘

B.
SELECT * FROM employee WHEREmidinit = NULL

C.
SELECT * FROM employee WHEREmidinit = ” “

D.
SELECT * FROM employee WHEREmidinit IS NULL