Oracle Exam 1Z0-071 Topic 5 Question 78 Discussion

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

Question #: 78
Topic #: 5

[All 1Z0-071 Questions]

Examine the description of the EMPLOYEES table:

NLS_DATE FORMAT is DD-MON-RR.

Which two queries will execute successfully?

ASELECT dept_ id, AVG (MAX(salary)) FROM employees GROUP By dept_id HAVING hire_date> ' O1-JAN-19';

BSELECT dept_ id, AVG(MAX(salary)) FROM employees GROUP BY dept_id, salary;

CSELECT dept id, MAX (SUM(salary)) FROM employees GROUP BY dept_id;

DSELECT dept_ iD, sum(salary) FROM employees WHERE hire_date > '01-JAN-9' GROUP BY dept_id;

ESELECT AVG(MAX(salary)) FROM employees GROUP BY salary;

Show Suggested Answer

Suggested Answer: A, C

by Luisa at Aug 08, 2023, 09:54 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Refugia

6 hours ago

The NLS_DATE_FORMAT is an important detail. It's good that the question specifies the date format, otherwise I might have gotten the date comparisons wrong.

upvoted 0 times

...

Kiley

1 days ago

Haha, I'm gonna choose option C just to see what kind of weird result I get. Maybe it'll summon the SQL gods or something.

upvoted 0 times

...

Daniel

15 days ago

E is definitely wrong, you can't group by salary alone. That would give you the average of the maximum salary for each unique salary value, which doesn't make much sense.

upvoted 0 times

...

Goldie

18 days ago

I think A and C are incorrect because they have some syntax errors. A is trying to use MAX() with AVG(), and C is trying to use SUM() with MAX().

upvoted 0 times

...

The correct answers are B and D. B calculates the average of the maximum salaries for each department, and D calculates the sum of salaries for employees hired after January 1, 2019 for each department.

upvoted 0 times

...

Mitzie

19 days ago

I'm not sure about option D. I think option B might also be correct because it groups by dept_id and salary.

upvoted 0 times

...

Clorinda

25 days ago

I agree with Mirta. Option A and D seem to be the correct queries based on the description of the table.

upvoted 0 times

...

Mirta

29 days ago

I think option A and D will execute successfully.

upvoted 0 times

...

Oracle Exam 1Z0-071 Topic 5 Question 78 Discussion

Contribute your Thoughts:

Refugia

Kiley

Daniel

Goldie

Marlon

Mitzie

Clorinda

Mirta