Given the table definition:
(CUSTNUM NUMERIC (6,0) NO DEFAULT NOT NULL,
CUSTNAME PIC X(20) DEFAULT NULL,
STREET VARCHAR(100) DEFAULT NULL,
CITY VARCHAR(40) DEFAULT NULL,
ZIP CHAR(5) DEFAULT “00000”)
Which INSERT command will fail with an error?

A.
INSERT INTO CUSTOMER (*) VALUES (12345, “ADAMS”, “5768 N Street”, “Palo Alto”,
“95123”);

B.
INSERT INTO CUSTOMER VALUES (12345, “ADAMS”, “5768 N Street”, “Palo Alto”, “95123”);

C.
INSERT INTO CUSTOMER VALUES (12345, “ADAMS”, “5768 N Street”, “Palo Alto”);

D.
INSERT INTO CUSTOMER (custnum, custname, street, city) VALUES (12345, “ADAMS”,
“5768 N Street”, “Palo Alto”);