Multiple choice

What type of view is implemented as a subquery embedded in the FROM clause of a SELECT statement and is identified by an alias?

  1. Simple

  2. Inline

  3. Complex

  4. Nested
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An inline view is a subquery that appears in the FROM clause and is treated like a table with an alias. Unlike a named view stored in the data dictionary, an inline view exists only for the duration of the query execution. It allows you to simplify complex queries and join derived result sets.

Keep practicing — related questions