Which two statements are true regarding views? (Choose two.)
A.
A sub query that defines a view cannot include the GROUP BY clause
B.
A view is created with the sub query having the DISTINCT keyword can be updated
C.
A Data Manipulation Language (DML) operation can be performed on a view that is
created with the sub query having all the NOT NULL columns of a table
D.
A view that is created with the sub query having the pseudo column ROWNUM keyword
cannot be updated