ITPub博客

首页 > 数据库 > Oracle > OCP 1Z0-051-87

OCP 1Z0-051-87

原创 Oracle 作者:LuiseDalian 时间:2014-05-17 07:20:36 0 删除 编辑
(87)You want to display the date for the first Monday of the next month and issue the following command:

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.

答案:(A)

解析:

D(X),有rrrr这种格式


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1163099/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: OCP 1Z0-051-83
请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6040880