Based on the Code Shown, Which Query Lists the Number

question 45

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

---

Definitions:

Dry Summers

Characteristic of the Mediterranean climate, referring to a period of the year with minimal rainfall and high temperatures.

Sequence

refers to the order of units in a biopolymer, like DNA, RNA, or proteins, or more generally to the arrangement of events or processes.

Equator

An imaginary line around the middle of the Earth, equidistant from both poles, dividing it into the Northern and Southern Hemispheres.

Biomes

Large ecological areas on the Earth's surface, with flora and fauna adapting to their environment, such as forests, deserts, and tundras.