PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply