A view may not be updated directly if it contains:
A) the distinct keyword.
B) derived columns and expressions in the select clause.
C) uses the group by or having clause.
D) all of the above.

Question

Quizplus · Accepted Answer

- The distinct keyword in a view can prevent direct update as it creates a virtual table that may not correspond directly to an underlying table.
- Derived columns and expressions in the select clause can also make it difficult to determine how to update the view and underlying table, making direct update impossible.
- Similarly, the use of group by or having clause can make it difficult to update the view and underlying table directly. Therefore, all of the above factors can prevent direct update of a view.

A View May Not Be Updated Directly If It Contains