DML operations are not allowed on a view that is created with the ____ keyword.
A) JOIN
B) NATURAL JOIN
C) DISTINCT
D) REPLACE

Question

DML operations are not allowed on a view that is created with the ____ keyword.​
A) ​JOIN
B) ​NATURAL JOIN
C) ​DISTINCT
D) ​REPLACE

Quizplus · Accepted Answer

When a view is created with the DISTINCT keyword, it removes duplicate rows from the result set. Since the view is created with a distinct keyword, the exact rows that need updating, deleting, or inserting may not be identified, so DML operations on such views are not allowed.

DML Operations Are Not Allowed on a View That Is