Multiple Choice
Based on the code above,list the number,name,and complete address of every customer located on a street that contains the letters "Oxford".
A) SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "?Oxford" ;
B) SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "%Oxford%" ;
C) SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "@Oxford@" ;
D) SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "Oxford" ;
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Instead of listing all the field names
Q10: In a SELECT statement, the WHERE clause
Q23: Preceding a condition by the NOT operator
Q31: Based on the code above,list the number,name,street,and
Q43: How does the format for dates in
Q49: Based on the code above,list the name
Q50: You can combine values in character fields
Q52: To create numbers with decimals in Access,you
Q53: Based on the code above,list the descriptions
Q60: The two tables involved in a union