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.