071考試不僅是OCP11g的考試科目，同時也是OCP 12c的考試科目，所以關心071考題的同學有很多，對此我們專門收集整理了近期071考試的原題，并對這些考題進行講解，希望幫助廣大考生順利通過071考試。
--------------------------------------------
071考題解析-第62題、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
(解析：工作中會用到把查出來的列的值去重合并成一行顯示，可以使用 listagg() WITHIN GROUP () 將
多行合并成一行：
）
-----------------------------------------------
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：https://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯系咨詢老師進群參與
