ocp 11g試題解析：1Z0-051-040題，完整題庫請點擊這里聯(lián)系老師咨詢了解

40. View the Exhibit to examine the description for the SALES and PRODUCTS tables.

You want to create a SALE_PROD view by executing the following SQL statement:

CREATE VIEW sale_prod

AS SELECT p.prod_id, cust_id, SUM(quantity_sold) "Quantity" , SUM(prod_list_price) "Price"

FROM products p, sales s

WHERE p.prod_id=s.prod_id

GROUP BY p.prod_id, cust_id;

Which statement is true regarding the execution of the above statement?

A. The view will be created and you can perform DML operations on the view.

B. The view will be created but no DML operations will be allowed on the view.

C. The view will not be created because the join statements are not allowed for creating a view.

D. The view will not be created because the GROUP BY clause is not allowed for creating a view.

Answer: B

試題解析：

A錯誤，此視圖為復(fù)雜視圖，帶有g(shù)roup by子句，不能對視圖進行DML操作，

B正確，可以創(chuàng)建成功，但不能進行DML操作。

C錯誤，可以通過join來連接兩張表創(chuàng)建視圖。

D錯誤，可以通過group by 子句來創(chuàng)建視圖。