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:

Home Mortgage Securitization

The process of bundling home loans into securities that are then sold to investors.

Mortgage Originators

Mortgage Originators are institutions or individuals that work with borrowers to complete a mortgage transaction, including the creation and processing of home loans.

Asset Liquidity

A measure of how easily an asset can be converted into cash without significantly affecting its market price.

Default Risk

The probability that a borrower fails to meet the obligations of paying back the interest or principal on a debt on time.