【云贝教育】Oracle 19c OCP 082题库解析(3)

考试科目：1Z0-082
考试题量：90
通过分数：60%
考试时间：150min
本文为云贝教育郭一军（微信：guoyJoe）原创，请尊重知识产权，转发请注明出处，不接受任何抄袭、演绎和未经注明出处的转载。

3. Examine the description of the products table
A.SELECT prod_id, AVG(MAX (cost)) FROM products GROUP BY prod.
B.SELECT prod_id, MAX (AVG (cost)) FROM products GROUP BY prod_id.
C.Select prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id
D.SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date

参考答案：D

解析：

AC不对，出现在group by 和select  from 必须一致
B不对,多了MAX，如果在SELECT中用MAX，那么就要去掉：prod_id字段

create table products(
prod_id number not null,
prod_name varchar2(40),
cost number(8,2),
release_date date
);