Which of the following describes a subquery used in a FROM clause to create a "temporary" table that can be referenced by the SELECT and WHERE clauses of the outer query?
A) simple view
B) complex view
C) inline view
D) "TOP-N" analysis

Question

Which of the following describes a subquery used in a FROM clause to create a "temporary" table that can be referenced by the SELECT and WHERE clauses of the outer query?​
A) ​simple view
B) ​complex view
C) ​inline view
D) ​"TOP-N" analysis

Quizplus · Accepted Answer

A subquery used in a FROM clause to create a "temporary" table is called an inline view. It allows for more complex queries to be executed by creating a temporary table that can be referenced by the outer query, and is commonly used in conjunction with aggregate functions or to perform a JOIN operation. Simple view and complex view refer to saved queries that can be used as tables, while "TOP-N" analysis is a technique for limiting the number of results returned by a query.

Which of the Following Describes a Subquery Used in a FROM Clause