A ________ is a temporary table used in the FROM clause of an SQL query.
A) correlated subquery
B) derived table
C) view table
D) none of the above

Question

Quizplus · Accepted Answer

A derived table is a temporary table that is created within the query and used in the FROM clause. It allows for more complex queries and helps to simplify the code by avoiding the need to create and manage a separate table. Correlated subqueries and view tables are not the same as derived tables.

A ________ Is a Temporary Table Used in the FROM Clause