Exam 1z0-061 topic 4 question 96 discussion

Actual exam question from Oracle's 1z0-061

Question #: 96
Topic #: 4

Examine the structure of the EMPLOYEES table:

You want to generate a report that contains the department IDs and last names of employees ordered by hire date in their respective departments. Employees from one department must appear in a single row.
Which query will provide the required output?

A. SELECT department_id "Dept.", LISTAGG (last_name, ‘;’) WITHIN GROUP (ORDER BY hire_date)" Employees" FROM employees GROUP BY department_id ORDER BY department_id;
B. SELECT department_id "Dept.", LISTAGG (last_name, ‘;’) WITHIN GROUP (ORDER BY hire_date)" Employees" FROM employees GROUP BY department_id ORDER BY hire_date;
C. SELECT department_id "Dept.", LISTAGG (last_name, ‘;’) WITHIN GROUP (ORDER BY hire_date)" Employees") FROM employees GROUP BY department_id ORDER BY hire_date;
D. SELECT department_id "Dept.", LISTAGG (last_name, ‘;’) WITHIN GROUP ORDER BY (hire_date)" Employees") FROM employees GROUP BY department_id ORDER BY department_id;

Show Suggested Answer

Suggested Answer: C 🗳️

by Jake at April 18, 2019, 5:22 p.m.

Comments

Submit Cancel

winston

1 year, 3 months ago

CORRECT ANSWER IS A

upvoted 1 times

...

hggz

5 years, 2 months ago

I think B is correct

upvoted 1 times

...

Jake

5 years, 8 months ago

typo in this one

upvoted 1 times

...

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam

Exam 1z0-061 topic 4 question 96 discussion

Comments

winston

hggz

Jake

SY0-701