Which three view types are not updateable?
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
Explanation:
Reference:
http://dev.mysql.com/doc/refman/5.0/en/view-updatability.html
ABD
BD and not sure about the third option
A,B,D
https://dev.mysql.com/doc/refman/5.6/en/view-updatability.html
A,B,D
A B D