Multiple choice technology databases

Which best describes an inline view?

  1. a schema object

  2. a subquery that can contain an ORDER BY clause

  3. another name for a view that contains group functions

  4. a subquery that is part of the FROM clause of another query
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An inline view is a subquery included in the FROM clause of a SELECT statement, which the database treats as a temporary table. Options A, B, and C are incorrect - it is not a schema object, not defined by ORDER BY support, and not merely a view with group functions.

Keep practicing — related questions