【OCP 12c】最新Oracle 1Z0-071考試題庫（17題）
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢2018年OCP 11g考試原題解析已經講解30多次課，500多道考試原題，最終達到98%以上的考題覆蓋度及95%以上的考試通過率。
2019年OCP 11g將升級到12c，OCP 12c考試解析免費公開課也已經開始了，歡迎大家收看!
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯系咨詢老師進群參與
-------------------------------------------------------
17.choose the best answer
View the Exhibit and examine the description of the EMPLOYEES table.
Evaluate the following SQL statement:
SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date,6),1) "Review" FROM employees;
The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the first Monday after the completion of six months
of the hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session.
Which statement is true regarding this query?
A) The query would not execute because the NEXT_DAY function accepts a string as argument.
B) The query would execute to give the desired output.
C) The query would not execute because date functions cannot be nested.
D) The query would execute but the output would give review dates that are Sundays.
Answer：D
(解析：題目的意思是顯示某個時間以后第一個周一的日期，但是西方人的第一天是星期天，
所以應該修改為 NEXT_DAY(ADD_MONTHS(hire_date,6),2)
步驟：
SQL> alter session set NLS_TERRITORY=america;
SQL> select next_day(sysdate,2) from dual;
NEXT_DAY(SYSDA
--------------
03-12 月-18 #這一天是周日
SQL> select next_day(sysdate,1) from dual;
NEXT_DAY(SYSDA
--------------
02-12 月-18 #這一天是周一
