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題庫(kù)直播也同步進(jìn)行中，OCM最新題庫(kù)大爆料-【每周四晚8點(diǎn)】，【微信群直播】，可以聯(lián)系咨詢老師進(jìn)群參與

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

30、(5-5) choose the best answer

View the Exhibit and examine the structure of the SALES and STORES tables.

You want to display the store name and the total quantity sold for each item in the store.

Which SQL statement will give the required output?

A) SELECT str.name, s1.items_id, SUM(s1.quantity)

FROM sales s1 JOIN stores str

ON (s1.store_id = str.store_id)

GROUP BY str.name, s1.items_id, s1.quantity;

B) SELECT str.name, s1.items_id, SUM(s1.quantity)

FROM sales s1 JOIN stores str

ON (s1.store_id = str.store_id)

GROUP BY str.name, s1.items_id;

C) SELECT str.name, s1.items_id,

(SELECT SUM(quantitY)

FROM sales sls

ON sls.store_id = s1.store_id

GROUP BY sls.store_id)

FROM sales s1 JOIN stores str

ON (s1.store_id = str.store_id);

D) SELECT str.name, s1.items_id, SUM(s1.quantity)

FROM sales s1 JOIN stores str ON (s1.store id = str.store_id)

GROUP BY s1.items_id, s1.quantity;

Answer：B

(解析：分組函數(shù)的最基本特點(diǎn)，沒有出現(xiàn)在分組函數(shù)中的列必須要出現(xiàn)在 group by 子句中。)