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, 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
Q10: In a SELECT statement, the WHERE clause
Q17: What are some common restrictions placed on
Q20: There is no difference between the COUNT
Q38: Fields will appear in the query results
Q39: To use a wildcard,include the _ operator
Q42: When you need to sort data on
Q43: Words that are part of the SQL
Q44: When you connect simple conditions using the
Q46: When a subquery is used,_ is(are)evaluated first.<br>A)
Q52: The _ of two tables is a