Based on the SQL Shown, Which Query Finds How Many

question 25

Multiple Choice

Based on the SQL shown, which query finds how many items are in the TOY category? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )

• A)SELECT SUM(*) FROM Items WHERE Category='TOY' ;
• B)SELECT COUNT(*) FROM Items WHERE Category='TOY' ;
• C)SELECT COUNT FROM Items WHERE Category='TOY' ;
• D)SELECT COUNT* FROM Items WHERE Category='TOY' ;

---

Definitions:

Perfect Competition

A market setup where numerous buyers and sellers interact, offering identical products, with no barriers to entry or exit, and complete transparency of information, resulting in suppliers having no control over prices.

Monopoly

A market structure characterized by a single seller, selling a unique product in the market. This seller faces no competition, as he is the sole seller of goods with no close substitute.

Output

refers to the total amount of goods or services produced by a firm, industry, or economy within a certain period.

Profit-Maximizing Rule

A principle stating that profit maximization occurs when a firm expands output until marginal cost is equal to marginal revenue.