当前位置：优技教育 >> ocp考试 >

ocp 11g考题大全：1Z0-051-092题

来源：优技教育更新时间：2016/8/5 14:35:05 阅读次数：766

ocp 11g考题大全：1Z0-051-092题，完整题库请点击这里联系老师咨询了解

92. View the E xhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of

the PROMOTIONS table, and the required output format.

Which two queries give the correct result? (Choose two.)

A. SELECT promo_name, TO_CHAR(promo_end_date,'Day') ', '

TO_CHAR(promo_end_date,'Month') ' '

TO_CHAR(promo_end_date,'DD, YYYY') AS last_day

FROM promotions;

B. SELECT promo_name,TO_CHAR (promo_end_date,'fxDay') ', '

TO_CHAR(promo_end_date,'fxMonth') ' '

TO_CHAR(promo_end_date,'fxDD, YYYY') AS last_day

FROM promotions;

C. SELECT promo_name, TRIM(TO_CHAR(promo_end_date,'Day')) ', '

TRIM(TO_CHAR(promo_end_date,'Month')) ' '

TRIM(TO_CHAR(promo_end_date,'DD, YYYY')) AS last_day

FROM promotions;

D. SELECTpromo_name,TO_CHAR(promo_end_date,'fmDay')','

TO_CHAR(promo_end_date,'fmMonth') ' '

TO_CHAR(promo_end_date,'fmDD, YYYY') AS last_day

FROM promotions;

Answer: CD

试题解析：

fm元素，用于删除填充的空格或隐藏前导零，TRIM也是截去字符串首字符或尾字符(或者两者都截去)

所有选CD

ORACLE授权认证机构CUUG: CUUG与ORACLE合作15年，是ORACLE金牌合作伙伴，连续多年处于行业领先；; CUUG与工信部人才交流中心合作，是工信人才指定的PostgreSQL数据库培训合作伙伴；; CUUG与阿里云、腾讯云、人大金仓、奥星贝斯等众多数据库厂商合作，开设数据库认证与培训课程；; CUUG与企业合作提供人才输送、定制化培训、技术支持服务；

北京优技教育科技有限公司

联系电话：010-59426307

课程咨询：010-59426319

联系地址：海淀区紫竹院路88号

Oracle认证 OCP认证 OCM认证