Sheng Has Been Asked to Provide Data from the Inventory

question 35

Multiple Choice

Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager.He has been given specific requirements to narrow the data based on the information the manager needs.Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
-Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save.If Sheng does this,he is creating a(n) ____.

• A)outer query
• B)subquery
• C)parent query
• D)filtered query

---

Definitions:

Operating Expenses

Costs associated with the day-to-day operations of a business, excluding costs linked to production or direct labor.

Industry Benchmark Information

Comparative data by which a company can measure its performance against that of other companies within the same industry.

Statistics Canada

Statistics Canada is the national statistical office of Canada, responsible for producing data on the Canadian economy, society, and environment that aids in informed decision-making.

Dun & Bradstreet Canada

A branch of the global corporation Dun & Bradstreet that specializes in providing commercial data, analytics, and insights for businesses in Canada.