Multiple choice technology databases

We can update the value of the columns that is selected on view list

  1. yes always

  2. yes on simple views with group by

  3. no on simple views with group by and distinct clause

  4. yesy on complex views
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Views containing GROUP BY or DISTINCT clauses are not updateable in SQL because the database cannot determine which rows to update uniquely. The question has significant issues: option B says 'yes' but should say 'no', option D has a typo ('yesy'), and the phrasing 'no on simple views with group by and distinct clause' is awkward. Despite quality issues, C is the intended correct answer as it correctly identifies the non-updateable case.

Keep practicing — related questions