【2020年8月】Oracle OCP 071考试新题(-14题)CUUG内部题库
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询【2020年8月】Oracle OCP 071考试新题(-14题)CUUG内部题库
Choose the best answer.
Examine this statement, which executes successfully:
SELECT d.department_name, ROUND (AVG (NULLIF (e.salary,0))) AS avgsal, MAX(e.salary) AS maxsal
FROM employees e
JOIN departments d
ON (e.department_id = d.department_id)
GROUP BY d. department_name
ORDER BY 2;
In which order are the rows displayed?
A) sorted by DEPARTMENT_NAME
B) sorted by MAXSAL
C) sorted by DEPARTMENT_NAME and AVGSAL
D) sorted by DEPARTMENT_NAME and MAXSAL
E) sorted by AVGSAL
2020年8月份Oracle OCP 071考试新题-14题)CUUG内部题库，钉钉群(35277291)Oracle金牌名师亲自题库解析
本文地址：http://www.cuug.com.cn/ocp/071kaoshitiku/25708996790.html 转载请注明！
