Exam 1z0-071 topic 1 question 105 discussion

Actual exam question from Oracle's 1z0-071

Question #: 105
Topic #: 1

Examine this description of the EMP table:

You execute this query:

What is the result?

A. only departments where the total salary is greater than 3000, returned in no particular order
B. only departments where the total salary is greater than 3000, ordered by department
C. all departments and a sum of the salaries of employees with a salary greater than 3000
D. an error

Show Suggested Answer

Suggested Answer: D 🗳️

by katsoufis at March 7, 2023, 8:51 a.m.

Submit Cancel

6 months, 2 weeks ago

Answer D, since in GROUP BY clause must used column names instead positioned numbers like here, like GROUP BY deptno - works fine

upvoted 1 times

...

1 year, 7 months ago

D ORA-00979: not a GROUP BY expression

upvoted 1 times

...

1 year, 11 months ago

why D? A is correct

upvoted 1 times

1 year, 10 months ago

Because the Group by requires all items in the select clause

upvoted 4 times

...

1 year, 10 months ago

Correction: One can order by 1 but you have to name the group by columns

upvoted 2 times

...