Oracle Exam 1Z0-071 Topic 13 Question 48 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 48
Topic #: 13

Examine the data in the EMP table:

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?

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

BAn allas name must not contain space characters.

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

DAn alias name must always be specified in quotes.

Show Suggested Answer

Suggested Answer: C

by Andra at May 04, 2022, 12:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!