Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work?
INSERT INTO store values ('234 Park Street')

A) It would work just fine.
B) You must specify the fields to insert if you are only inserting some of the fields.
C) There is no table keyword.
D) INSERT INTO should be INSERT to.

Question

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work?
 INSERT INTO store values ('234 Park Street')

A) It would work just fine.
B) You must specify the fields to insert if you are only inserting some of the fields.
C) There is no table keyword.
D) INSERT INTO should be INSERT to.

Quizplus · Accepted Answer

You must specify the fields to insert if you are only inserting some of the fields, otherwise, you need to provide values for all fields.

Given a Table Named Store with 5 Fields: Store_id, Address