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

Quizplus · Accepted Answer

The insert command is trying to insert only one value, but there are five fields in the table. Therefore, the command must specify which fields are being inserted and in what order.

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