Oracle
1Z0-071 · Question #253
1Z0-071 Question #253: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #253. The question stem and answer options stay visible for context.
Question
You need to list the employees in DEPARTMENT_ID 20 days in a single row, ordered by HIRE_DATE. Examine the sample output: Which query will provide the required output?
Options
- ASELECT LISTAGG(last_name)
- BSELECT LISTAGG(last_name, '; ')
- CSELECT LISTAGG(last_name, '; ') "Emp_list", MIN(hire_date) "Earliest" FROM employees
- DSELECT LISTAGG(last_name, '; ') "Emp_list", MIN(hire_date) "Earliest" FROM employees
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.