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

Verified
Correct Answer:
Verified
Q6: SQL uses an on-screen form to create
Q32: A valid name for a table might
Q33: In Access SQL, which character is used
Q34: Based on the code shown, which query
Q35: The _ data type stores integers in
Q38: Based on the code shown, which query
Q39: Which operator do you use in the
Q40: A WHERE and a HAVING clause cannot
Q41: You can combine values in character fields
Q42: Which function calculates the number of entries