【ocp-12c】最新Oracle OCP-071考试题库（38题）

View the Exhibit and examine the data in the PROMOTIONS table.

PROMO_BEGIN_DATE is stored in the default date format,dd-mon-rr.

You need to produce a report that provides the name,cost,and start date of all promos

in the POST category that were launched before January 1,2000.

Which SQL statement would you use?

A) SELECT promo_name,promo_cost,promo_begin_date

FROM promotions

WHERE promo_category LIKE ‘%post%‘ AND promo_begin_date < ‘1-JAN-00‘;

B) SELECT promo_name,promo_begin_date

FROM promotions

WHERE promo_category = ‘post‘ AND promo_begin_date < ‘01-01-00‘;

C) SELECT promo_name,promo_begin_date

FROM promotions

WHERE promo_cost LIKE ‘post%‘ AND promo_begin_date < ‘01-01-2000‘;

D) SELECT promo_name,Promo_begin_date

FROM promotions

WHERE promo_category LIKE ‘p%‘ AND promo_begin_date < ‘1-JANUARY-00‘;

Answer：A

(解析：因为日期的默认格式是 dd-mon-yy，所以 January 1,2000 转换成匹配的格式为

01-jan-00

)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!