Oracle

1Z0-882 · Question #69

Which three view types are not updateable?

The correct answer is A. A view created with the TEMPTABLE algorithm B. A view containing a GROUP BY clause D. A view containing a HAVING clause. See the full explanation below for the reasoning.

Question

Which three view types are not updateable?

Options

AA view created with the TEMPTABLE algorithm
BA view containing a GROUP BY clause
CA view containing a WHERE clause
DA view containing a HAVING clause
EA view that contains a literal column

How the community answered

(23 responses)

A
78% (18)
C
13% (3)
E
9% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-882 Practice