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:

Consolidated Income Statement

A financial statement that combines and presents the total income and expenses of a parent company and its subsidiaries, showing the net profit or loss of the entire group.

Debt Acquisition

The process of obtaining debt financing or purchasing existing debt from another entity.

Gain Or Loss

The financial result that occurs when the selling price of an asset differs from its original purchase price.

Goodwill

Goodwill represents the excess of the purchase price over the fair value of the net assets of a business acquired. It reflects intangible assets such as brand reputation, customer relationships, and intellectual property.