Based on the Code Above,list the Number,name,and Complete Address of Every

question 48

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

---

Definitions:

Reservoirs

Artificial lakes or storage areas created by constructing dams across rivers or streams to store water for various purposes such as irrigation, power generation, and drinking water supply.

Electric Power

The flow of electrical energy through a conductor, used for a multitude of applications including lighting, heating, and powering machinery.

Drinking Water

Water that is safe and clean for human consumption without the risk of health problems.

Aquifers

Geological formations that can store, transmit, and yield water to a well or spring.