Multiple choice technology databases

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

  1. Inline

  2. Simple

  3. Complex

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

An inline view is a subquery in the FROM clause of a SELECT statement, identified by an alias, acting as a temporary virtual table. Simple and complex views are stored schema objects created with the CREATE VIEW statement. Nested view is not a standard terminology for this specific construct.

Keep practicing — related questions