Oracle Exam 1Z0-071 Topic 10 Question 20 Discussion

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

Question #: 20
Topic #: 10

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

ASelect deptno. no LISTAGG(ename, ',') WITHIN GROUP (GROUP BY deptno) AS employee-list
FROM emp
ORDER BY emp

BSelect deptno. LISTAGG(ename, ',') WITHIN GROUP AS employee-list
FROM emp
GROUP BY emp

CSelect deptno. LISTAGG(ename, ',') WITHIN GROUP AS employee-list
FROM emp
ORDER BY ename;

DSelect deptno. no LISTAGG(ename, ',') WITHIN GROUP(ORDER BY ename) AS employee-list
FROM emp
ORDER BY emp

Show Suggested Answer

Suggested Answer: D

by Joseph at May 03, 2022, 06:22 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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