Multiple Choice
Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.
A) SELECT Description FROM Item 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 Customer WHERE Storehouse='3' AND OnHand>20 ;
Correct Answer:

Verified
Correct Answer:
Verified
Q22: To add new data to a table,use
Q23: Preceding a condition by the NOT operator
Q25: The basic form of an SQL retrieval
Q28: You can save the results of a
Q29: In Access SQL,the _ is used as
Q30: The IN operator provides a concise way
Q31: Based on the code above,list the number,name,street,and
Q32: Describe how to construct a detailed query
Q43: Describe five data types that you will
Q74: Use the _ data type for fields