大數據就業實戰培訓 Oracle就業實戰培訓
071考試題庫之前是比較穩定的，但隨著Oracle的調整，071考試不斷的增加新的考題，增加了考試的難度，所以我們專門收集整理了這些考試，并對這些考題進行解析，希望可以對考生有幫助。
每周五晚8點，我們有免費的OCP解析公開課，地址：https://ke.qq.com/course/326223 OCP題庫交流群：1015267481，驗證ocp
-------------------------------------------------------
071考試-第30題、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
(解析：分組函數的最基本特點，沒有出現在分組函數中的列必須要出現在 group by 子句中。)
