Which of the following statements are true?
A.
A view created with the temptable algorithm is not updatable.
B.
A view containing a group BY clause is not updatable.
C.
A view containing a where clause is not updatable.
D.
A view containing a having clause is not updatable.
Explanation:
Updatable tables (created using the MERGE algorithm) can’t include constructs such as DISTINCT, aggregate functions, GROUP BY, HAVING or subquery in select list. p248.