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:

Non-interest-bearing Note

A financial instrument or loan that does not accrue interest over its life, meaning the borrower repays only the principal amount.

Actuarial Information

Data related to evaluating risks and determining rates or premiums in the insurance and finance industries, based on statistical analyses.

Conversion Privilege

A feature of certain securities that allows the holder to convert them into a different type of security, typically shares of the issuing company's stock.