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.
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
B.SELECT promo_name, promo_cost, promo_begin_date FROM promotions
WHERE 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
解析:题目说默认日期格式为dd-mm-rr,因此排除ABC
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?
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
B.SELECT promo_name, promo_cost, promo_begin_date FROM promotions
WHERE 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
解析:题目说默认日期格式为dd-mm-rr,因此排除ABC