Multiple choice technology databases

One can NOT delete a row from the VIEW if view definition contains ... Choose all that apply

  1. WHERE clause

  2. GROUP BY clause

  3. GROUP functions

  4. DISTINCT keyword

  5. FROM clause
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

A view is not deletable if its query contains aggregate functions, GROUP BY clauses, or the DISTINCT keyword, as the system cannot map the deletion to specific source table rows. A view must have a FROM clause and can optionally have a WHERE clause without affecting delete support.

Keep practicing — related questions