Oracle
1Z0-071 · Question #253
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?
The correct answer is B. SELECT LISTAGG(last_name, '; '). See the full explanation below for the reasoning.
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
How the community answered
(28 responses)- A4% (1)
- B79% (22)
- C4% (1)
- D14% (4)
Community Discussion
No community discussion yet for this question.