Oracle Exam 1Z0-071 Topic 13 Question 67 Discussion

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

Question #: 67
Topic #: 13

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: D, E

by Tamar at Dec 08, 2022, 11:33 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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