Oracle.1Z0-051.175q(24)

OCP 11g 051题库

QUESTION 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?

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新小学教育Oracle.1Z0-051.175q(24)全文阅读和word下载服务。