OCP 1Z0 051 87

87.  You  want  to  display  the  date  for  the  first  Mon  day  of  the  next   month  and  issue  the  following 
command: 
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),                    
'dd "is the first Monday for" fmmonth rrrr') 
FROM DUAL; 
What is the outcome? 
A. It executes successfully and returns the correct result. 
B. It executes successfully but does not return the correct result. 
C. It generates an error because TO_CHAR should be replaced with TO_DATE. 
D. It generates an error because rrrr should be replaced by rr in the format string. 
E. It generates an error because fm and double quotation marks should not be used in the format string. 

last_day是取当月最后一天
next_day是取下一个（星期几）
对于时间
to_char()是把时间转换为字符串格式
to_date()是把时间转换为日期格式
rrrr年份显示为四位
rr只显示年份后两位
fm去掉返回值中的空格

SQL> SELECT to_char(next_day(last_day(SYSDATE), 'MON'),
  2                 'dd "is the first Monday for" fmmonth rrrr')
  3    FROM dual;
TO_CHAR(NEXT_DAY(LAST_DAY(SYSD
---------------------------------------------
02 is the first Monday for june 2014
1 row selected

SQL> SELECT to_date(next_day(last_day(SYSDATE), 'MON'),
  2                 'dd "is the first Monday for" fmmonth rrrr')
  3    FROM dual;
SELECT to_date(next_day(last_day(SYSDATE), 'MON'),
               'dd "is the first Monday for" fmmonth rrrr')
  FROM dual
ORA-01861: 文字与格式字符串不匹配

SQL> SELECT to_char(next_day(last_day(SYSDATE), 'MON'), 'dd "is the first Monday for" fmmonth rr') FROM dual;
TO_CHAR(NEXT_DAY(LAST_DAY(SYSD
-------------------------------------------
02 is the first Monday for june 14
1 row selected

SQL> SELECT to_char(next_day(last_day(SYSDATE), 'MON'), 'dd "is the first Monday for" month rrrr') FROM dual;
TO_CHAR(NEXT_DAY(LAST_DAY(SYSD
---------------------------------------------
02 is the first Monday for june      2014
1 row selected

注意没有fm时多出来的空格

Answer: A