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' ;
Correct Answer:

Verified
Correct Answer:
Verified
Q20: List five Access data types and their
Q21: Which SQL keyword can you use to
Q22: Explain the requirements of two sets of
Q23: In an Access query, a "group" of
Q24: Based on the SQL shown, which query
Q26: Which query will return the number of
Q27: When you create a query using SQL
Q28: Which part of a SQL query specifies
Q29: In what type of SQL operation must
Q30: When a SQL statement consists of two