OCP-1Z0-051 第40题视图的注意事项

最新推荐文章于 2023-12-04 08:01:07 发布

hello_holly

最新推荐文章于 2023-12-04 08:01:07 发布

阅读量4.3k

点赞数 1

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 视图 view group by join

本文链接：https://blog.csdn.net/holly2008/article/details/24577669

版权

OCP-1Z0-051 专栏收录该内容

220 篇文章

订阅专栏

一、原题

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操作。