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

Question

Quizplus · Accepted Answer

If Sheng creates a second SELECT statement within the query used to create the datasheet containing the filter, he is creating a subquery. A subquery is a query nested inside another query and is used to retrieve data that will be used by the main query as a condition to further restrict the data to be retrieved.

Sheng Has Been Asked to Provide Data from the Inventory