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:

Property Rights

Legal rights to possess, use, and dispose of assets including real estate, personal property, or intellectual property.

Workers' Rights

The entitlements and protections granted to workers by law, including fair pay, safe working conditions, and the right to unionize.

Labor Union

An organization of workers formed to protect and advance their members' interests regarding working conditions, wages, and benefits.

Industrial Democracy

A model or concept where workers have a direct or indirect say in the management and decision-making processes of their workplace.