Multiple choice

A view was created containing groups of data. It does not allow DML operations, and does not contain a subquery. What type of view was created?

  1. Inline

  2. Simple

  3. Complex

  4. Explicit
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A complex view contains GROUP BY clauses, DISTINCT expressions, or aggregate functions, which prevent DML operations through the view. The presence of GROUP BY makes this view complex by definition. Simple views allow DML operations and don't have such complexity. Inline views are subqueries in the FROM clause, not a separate view type. Explicit refers to how the view is created, not its characteristics.

Keep practicing — related questions