OCP-1Z0-051-题目解析-第40题

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：视图能被创建，并且能执行DML操作（错误，创建视图语句中含有group by子句，为复杂视图，不可执行DML操作）
B：视图被创建，但不能执行DML操作（正确）
C：视图不能被创建，因为join语句不允许使用在创建视图中（错误，创建视图可以使用多表）
D：视图不能被创建，因为group by子句不能使用在创建视图中（错误，使用group by 创建的是复杂视图）