OCP-051-002

2. 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 v3
AS SELECT * FROM SALES WHERE cust_id = 2034
WITH CHECK OPTION;

B. CREATE VIEW v1
AS SELECT * FROM SALES
WHERE time_id <= SYSDATE - 2*365
WITH CHECK OPTION;
C. CREATE VIEW v2
AS SELECT prod_id, cust_id, time_id FROM SALES
WHERE time_id <= SYSDATE - 2*365
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;


---updateable的視圖有二種,一種是繼承基表的視圖, 一種是使用instead of的觸發器來實現

繼承的視圖DML操作需要滿足一下條件:
1. 視圖必須包含基表的每一列.
2. 視圖不能包含一下操作: set, distinct, aggregate or analytic function, group by, order by, model, connect by, start with
                                   subquery in select, with read only.