2018年OCP 11g考試原題解析已經(jīng)講解30多次課，500多道考試原題，最終達到98%以上的考題覆蓋度及95%以上的考試通過率。

2019年OCP 11g將升級到12c，OCP 12c考試解析免費公開課也已經(jīng)開始了，歡迎大家收看!

OCP解析公開課時間：【每周五晚8點】

OCP解析公開課地址：http://ke.qq.com/course/326223

OCP解析群資料分享：1015267481 驗證：ocp

另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯(lián)系咨詢老師進群參與

-------------------------------------------------------

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 轉(zhuǎn)換成匹配的格式為

01-jan-00

)