Oracle Database MySQL 5.6 Developer — Question 9

Which three view types are not updateable?

Answer options

• A. A view created with the TEMPTABLE algorithm
• B. A view containing a GROUP BY clause
• C. A view containing a WHERE clause
• D. A view containing a HAVING clause
• E. A view that contains a literal column

Correct answer: B, C, D

Explanation

The correct answer includes views that contain aggregate functions or filtering conditions, which make them non-updateable. Options B, C, and D involve clauses that aggregate or restrict data, preventing updates. Option A, while specific, does not restrict updates, and option E does not affect the updateability of the view.