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

question 34

Multiple Choice

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.

---

Definitions:

Bulk Purchase Discount

A reduction in price offered by suppliers to customers who buy large quantities of goods.

Lower Quality Materials

Substandard or inferior raw materials used in the production process, typically resulting in a lower cost and quality of the final product.

Direct Labor Wage Variance

The difference between the actual cost of direct labor and the expected (or standard) cost, used in budgeting and financial analysis.

Total Labor Variance

The difference between the actual labor costs and the standard or budgeted labor costs for a production process.