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

最新推荐文章于 2024-07-21 12:14:06 发布

hello_holly

最新推荐文章于 2024-07-21 12:14:06 发布

阅读量4.7k

点赞数 2

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 日期格式 date 11g

本文链接：https://blog.csdn.net/holly2008/article/details/24691435

版权

OCP-1Z0-051 专栏收录该内容

220 篇文章 6 订阅

订阅专栏

一、原题

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 条件不对。