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.)

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;



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Mamta

Mamta

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;

Mamta

Mamta

1 1 18-JAN-14

davor

davor

You can not INSERT on V2 because of NOT NULL constraints on other columns.

bob

bob

To clarify:

Which views can have >> all << DML operations performed on it?

Steve

Steve

views without group functions and all the not null columns are on the view and not read only option