Multiple choice technology databases

We can not remove a row from view, if it contains

  1. Group functions

  2. Group by clause

  3. Distinct keyword

  4. All of above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Views cannot be used for DELETE if they contain GROUP BY, DISTINCT, or group functions (aggregate functions like COUNT, SUM). These constructs create derived/aggregate data that cannot be mapped back to individual rows.

Keep practicing — related questions