[OCP 12c] the latest CUUG OCP-071 examination questions bank (62 questions)

62, (13-17) choose the best answer

You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.

Examine the sample output:

Which query will provide the required output?

A) SELECT LISTAGG (last_name,';') "Emp_list", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

WITHIN GROUP ORDER BY hire_date

B) SELECT LISTAGG (last_name,';') "EMP_LIST", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

ORDER BY hire_date

C) SELECT LISTAGG (last_name,';')

WITHIN GROUP (ORDER BY hire_date) "Emp_list", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

D) SELECT LISTAGG (last_name)

WITHIN GROUP ORDER BY (hire_date) "Emp_list", MIN (hire_date) "Earliest"

FROM employees

WHERE department_id = 30

Answer:C

(parsing: the values of the checked columns will be used to overlap and display in a row. You can use listagg () WITHIN GROUP () to display the

Multiple lines are merged into one line:

)