Multiple Choice
Based on the code shown, which query lists the number, name, and complete address of every customer located on a street that contains the letters "Oxford"???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
A) SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "?Oxford" ;
B) SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ;
C) SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "@Oxford@" ;
D) SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "Oxford" ;
Correct Answer:

Verified
Correct Answer:
Verified
Q39: While not always required, how should you
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
Q44: You can use the GROUP BY clause
Q46: What command do you use to add
Q47: Use the word _ in the query
Q49: When you connect simple conditions using the
Q50: What clause do you use in a