OCP-1Z0-051-Question Analysis-2nd Question

2. View the Exhibit to examine the description for the SALES table.

Which views can have all DML operations completed MED on it? (Choose all that apply .)

A.

 CREATE VIEW v3AS SELECT * FROM SALES   WHERE cust_id = 2034   WITH CHECK OPTION;

B.

CREATE VIEW v1AS SELECT * FROM SALES   WHERE time_id <= SYSDATE - 2*365   WITH CHECK OPTION;

C.

CREATE VIEW v2AS SELECT prod_id, cust_id, time_id FROM SALES   WHERE time_id <= SYSDATE - 2*365   WITH CHECK OPTION; 

D.

CREATE VIEW v4AS 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;

Answer: AB

Question Analysis:

The question is: which view can perform all DML operations. We know that to perform the insert operation on the view, the view must contain all non-empty fields in the base table, therefore, it can be clearly determined that C and D are incorrect, and the SUM (quantity_sold) of the D option is also incorrect. aliases must be added for this field.