OCP-1Z0-051 第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

答案：B

二、题目翻译

查看下面SALES 和 PRODUCTS表结构
下面是创建SALE_PROD视图的sql语句：
关于上面的语句哪句话是正确的？
A. 视图会创建成功，并且可以在视图上执行DML操作。
B. 视图会创建成功，但是不能在视图上进行DML操作。
C. 视图创建失败，因为视图不能使用join语句。
D. 视图创建失败，因为视图不能使用GROUP BY语句。

三、题目解析

  视图可以使用join,group by等子句，但复杂视图不能进行DML操作，只有简单视图可以进行DML操作。