2018年OCP 11g考試原題解析已經(jīng)講解30多次課，500多道考試原題，最終達(dá)到98%以上的考題覆蓋度及95%以上的考試通過率。

2019年OCP 11g將升級(jí)到12c，OCP 12c考試解析免費(fèi)公開課也已經(jīng)開始了，歡迎大家收看!

OCP解析公開課時(shí)間：【每周五晚8點(diǎn)】

OCP解析公開課地址：http://ke.qq.com/course/326223

OCP解析群資料分享：1015267481 驗(yàn)證：ocp

另外，除了OCP公開課，OCM題庫直播也同步進(jìn)行中，OCM最新題庫大爆料-【每周四晚8點(diǎn)】，【微信群直播】，可以聯(lián)系咨詢老師進(jìn)群參與

-------------------------------------------------------

80、View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.

Which CREATE VIEW statement would create the views successfully?

A . AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)

FROM orders o JOIN order_items i

ON (o.order_id = i.order_id)

GROUP BY o.order_id, o.order_date;

B. CREATE OR REPLACE VIEW ord_vu (order_id, order_date)

AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)

"NO OF ITEMS"

FROM orders o JOIN order_items i ON

(o.order_id = i.order_id) GROUP BY o.order_id,

o.order_date;

C. CREATE OR REPLACE VIEW ord_vu

AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)

"NO OF ITEMS"

FROM orders o JOIN order_items i

ON (o.order_id = i.order_id) GROUP BY

o.order_id, o.order_date;

D. CREATE OR REPLACE VIEW ord_vu

AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id) ||

"NO OF ITEMS"

FROM orders o JOIN order_items i

ON (o.order_id = i.order_id) GROUP BY

o.order_id, o.order_date

WHITH CHECK OPTION;

Correct Answer: C

Section: (none) Explanation：A答案會(huì)報(bào)錯(cuò)：ORA-00998: 必須使用列別名命名此表達(dá)式，缺少一個(gè)別名;B答案視圖缺少一個(gè)列名，如果加上"NO OF ITEMS"就是正確的。