Which statement will return a comma-separated list of employee names in alphabetical order for each...

Vendor: Oracle
Product: 1z0-071
Update on: Jul 25, 2025
Questions: 326

Oracle 1z0-071 Question Answer

Which statement will return a comma-separated list of employee names in alphabetical order for each department in the EMP table?

SELECT deptno,LISTAGG(ename, ' , ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno;

SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno ORDER BY ename;

SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (GROUP BY deptno) AS employee_list FROM emp ORDER BY ename;

SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (ORDER BY ename) AS employee_list FROM emp GROUP BY deptno;

Oracle 1z0-071 Summary

Price: $52.5 ~~$149.99~~