【2020年8月】Oracle OCP 071考试新题(-14题)CUUG内部题库

【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金牌名师亲自题库解析