Given a table named store with 5 fields: store_id, address, city, state, zipcode

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')

I think it might be C. Please explain you answer!

Insert into should be INSERT to.

There is no table keyword.

You must specify the fields to insert if you are only inserting some of the fields.

It would work just fine.

Insert into should be INSERT to.

There is no table keyword.

You must specify the fields to insert if you are only inserting some of the fields.

It would work just fine.

Explanation / Answer

You must specify the fields to insert if you are only inserting some of the fields. This is the correct ans for it

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.