Which SQL SELECT Statement Determines the Criteria for the Rows

question 4

Multiple Choice

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

• A)WHICH
• B)WHO
• C)WHERE
• D)FROM

---

Definitions:

Periodic Inventory System

A method of inventory valuation where updates to inventory levels and cost of goods sold are made periodically at the end of an accounting period, rather than after each sale or purchase.

LIFO Method

An inventory valuation method that assumes the last items placed in inventory are the first sold during an accounting year.

Cost of Goods Sold

The direct costs attributable to the production of the goods sold by a company, including materials, labor, and overhead.

Weighted-Average

A calculation that takes into account the varying degrees of importance of the numbers in a data set, giving more weight to some numbers than others.