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 enclosed in parentheses and placed in the FROM clause of a parent query. It acts as a temporary virtual table during query execution and is not stored as a schema object in the database.

Keep practicing — related questions