Oracle Database 12c SQL 1z0-071 Question # 65 Topic 7 Discussion

Oracle Database 12c SQL 1z0-071 Question # 65 Topic 7 Discussion

1z0-071 Exam Topic 7 Question 65 Discussion:
Question #: 65
Topic #: 7

Examine the data in the EMP table:

1z0-071 Question 65

You execute this query:

SELECT deptno AS "Department", AVG(sal) AS AverageSalary, MAX(sal) AS "Max Salary"

FROM emp

WHERE sal >= 12000

GROUP BY "Department "

ORDER BY AverageSalary;

Why does an error occur?


A.

An alias name must not be used in an ORDER BY clause.


B.

An allas name must not contain space characters.


C.

An alias name must not be used in a GROUP BY clause.


D.

An alias name must always be specified in quotes.


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.