A subquery that defines a view cannot include the GROUP BY clause

A view is created with the subquery having the DISTINCT keyword can be updated

A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

A Data Manipulation Language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table