Based on the Code Shown, Which Query Finds How Many

question 37

Multiple Choice

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

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

---

Definitions:

Medical Equipment

Devices used in medical practice to diagnose, prevent, or treat diseases or medical conditions.

Cognitive Development

A process involving the growth and enhancement of mental abilities, such as thinking, reasoning, problem-solving, and understanding, throughout a person's life.

Formal Operations

The final stage of cognitive development in Piaget's theory, typically beginning around age 12, characterized by the ability to think abstractly, logically, and systematically.

Jean Piaget

A Swiss psychologist known for his pioneering work in child development, specifically his theory of cognitive development that explains how children construct a mental model of the world.