Which two statements are true regarding views? (Choose two.)
A.
A subquery that defines a view cannot include the GROUP BY clause.
B.
A view that is created with the subquery having the DISTINCT keyword can be updated.
C.
A view that is created with the subquery having the pseudo column ROWNUM keyword cannot
be updated.
D.
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.
Explanation:
Rules for Performing DML Operations on a View
You cannot add data through a view if the view includes:
Group functions
A GROUP BY clause
The DISTINCT keyword
The pseudocolumn ROWNUM keyword
Columns defined by expressions
NOT NULL columns in the base tables that are not selected by the view