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;
V2 can be updated also
create table sales
( prodid number not null,
custid number not null,
timeid number not null,
channelid number not null,
promoid number not null,
quantitysold number(10,2) not null);
CREATE or replace VIEW v2
AS SELECT prodid, custid, saledate FROM SALES
where saledate <= sysdate+1
WITH CHECK OPTION;
update v2
set saledate = sysdate+1
where prodid = 1;
select * from v2;
1 1 18-JAN-14
You can not INSERT on V2 because of NOT NULL constraints on other columns.
To clarify:
Which views can have >> all << DML operations performed on it?
views without group functions and all the not null columns are on the view and not read only option