近两年来，OCP的考试题库频率变化，不断的增加新考题，071考试就是其中一个，给很多考071的考生造成困扰，对此，我们专门整理了OCP考试里关于071考试的原题，并带上答案，分享给大家。
--------------------------------------------
20.choose the best answer
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_cost, promo_begin_date
FROM promotions
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
C) SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
D) SELECT promo_name, promo_cost, 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
)
--------------------------------------------
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：https://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与
