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" ;

Question

Quizplus · Accepted Answer

The '%Oxford%' pattern will match any string that contains 'Oxford', so this query will list all customers whose street contains 'Oxford' regardless of whether there are characters before or after 'Oxford' in the street name.

Based on the Code Shown, Which Query Lists the Number