Which views can have all DML operations performed on it?

View the Exhibit to examine the description for the SALES table. Which views can have all
DML operations performed on it? (Choose all that apply.)

A.
CREATE VIEW v2 AS SELECT prod_id, cust_id, time_id FROM SALES WHERE time_id
<= SYSDATE – 2*365 WITH CHECK OPTION;

B.
CREATE VIEW v1 AS SELECT * FROM SALES WHERE time_id <= SYSDATE – 2*365
WITH CHECK OPTION;

C.
CREATE VIEW v3 AS SELECT * FROM SALES WHERE cust_id = 2034 WITH CHECK
OPTION;

D.
CREATE VIEW v4 AS SELECT prod_id, cust_id, SUM(quantity_sold) FROM SALES
WHERE time_id <= SYSDATE – 2*365 GROUP BY prod_id, cust_id WITH CHECK
OPTION;

Explanation: