OCP 071中文考試題庫(cuug內部資料)第38題
本套題庫是OCP考試中的071(中文版)試題,由CUUG整理,如有報考OCP認證意向,可以聯系cuug咨詢老師。
38、請選擇兩項。
SALES表具有數據類型為NUMBER的PROD_ID 和QUANTITY_SOLD 列。
哪兩個查詢將成功執行?
A) SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
B) SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
C) SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
D) SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(*) > 10;
E) SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;