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

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

来源：优技教育

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

精华阅读