Multiple Choice
Based on the code shown, which query lists the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand, or both???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
A) SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;
B) SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ;
C) SELECT Description FROM Item WHERE Storehouse='3' ;
D) SELECT Description FROM Item WHERE OnHand>20 ;
Correct Answer:

Verified
Correct Answer:
Verified
Q6: SQL uses an on-screen form to create
Q33: In Access SQL, which character is used
Q34: Based on the code shown, which query
Q35: The _ data type stores integers in
Q37: 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
Q43: Describe five data types that you will