OCP-1Z0-051 补充题库 第45题 CREATE VIEW

一、原题

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

You want to create a SALE_PROD view by executing the following SQL statements:
    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