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:

Retained Earnings

Net earnings not distributed as dividends but reinvested back into the company or kept as a reserve for future use.

Net Loss

The amount by which a company's expenses exceed its revenues over a specific period, indicating a decrease in net assets.

Discontinued Operations

Components of a company's business that have been disposed of or are classified as held for sale, and whose financial results are separated from ongoing operations.

Extraordinary Items

Events and transactions that are distinguished by their unusual nature and by the infrequency of their occurrence, providing insight into a company's financial health.