【2020年8月】Oracle OCP 071考試新題(-14題)CUUG內(nèi)部題庫(kù)

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內(nèi)部題庫(kù)，釘釘群(35277291)Oracle金牌名師親自題庫(kù)解析