Ocp-1z0-051-Title Determination-Article 2 title

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

Which views can has all DML operations performed on it?

(Choose all, 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   

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

Topic Analysis:

The question is, which view is capable of running all DML operations, and we know that we want to run the insert operation on the view. Then the view is going to include all the non-empty fields of the base table, so it is obvious that C and D are wrong. In addition to the sum of the D option (Quantity_sold) This is wrong and the field will need to add an alias.

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

Ocp-1z0-051-Title Determination-Article 2 title