OCP-1Z0-051 第53题 日期格式

一、原题

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 = 'post' AND promo_begin_date < '01-01-00';
B. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    HERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
C. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
D. SELECT promo_name, promo_cost, promo_begin_date
    FROM promotions
    WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

答案：D

二、题目翻译

检查PROMOTIONS表的数据
PROMO_BEGIN_DATE列使用默认日期格式dd-mon-rr存储.
要生成一个报表，显示所有2000年1月1日之前的、促销种类为POST的promos的名称，成本和开始日期，
应该使用哪个SQL语句？

三、题目解析

A和B选项都不正确，promo_begin_date条件格式不对。
C选项不正确，promo_category 条件不对。