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:

Negative Consequences

Unfavorable or harmful outcomes resulting from an action or decision.

Voice-Mail Message

An electronic system that allows messages to be recorded and stored for later retrieval by the intended recipient.

Ignored

Not noticed or regarded as unimportant or irrelevant.

Pronunciation

The way in which a word is spoken, including its sounds and accent.