IBM Exam Questions

Which INSERT statement is NOT correct?

Given the following table:
USERS
————————–ID INTEGER NOT NULL
NAME CHAR(20) NOT NULL
PASSWORD VARCHAR(30)
Which INSERT statement is NOT correct?

A.
INSERT INTO USERS VALUES ( 23, ‘Jim’, ‘password’)

B.
INSERT INTO USERS VALUES ( 23, ‘Jim’, NULL )

C.
INSERT INTO USERS VALUES ( 23, ”, ‘password’)

D.
INSERT INTO USERS VALUES ( 23, NULL, ‘password’)

Explanation: