Multiple choice technology databases

Can we apply update, insert or delete on a view?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DML operations (INSERT, UPDATE, DELETE) can be performed on some views, but not all. Updatable views must meet conditions: derived from a single table, no DISTINCT, GROUP BY, aggregates, or computed columns. The modifications affect the underlying base tables. Simple views are generally updatable, complex views may be read-only.

Keep practicing — related questions