OCP-1Z0-051 第56题日期时间段

最新推荐文章于 2024-06-08 09:42:14 发布

hello_holly

最新推荐文章于 2024-06-08 09:42:14 发布

阅读量3.8k

点赞数 1

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 BETWEEN AND 时间段 11g

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

版权

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

220 篇文章

订阅专栏

一、原题

View the Exhibit and examine the structure of the PROMOTIONS table.
Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended in the time interval 15th March '00 to 15th October '00.
Which two queries would give the required result? (Choose two.)

A. SELECT promo_name, promo_cost
       FROM promotions
    WHERE promo_category IN ('TV', 'internet')
         AND  promo_end_date BETWEEN '15-MAR-00' AND '15-OCT-00';
B. SELECT promo_name, promo_cost
       FROM promotions
     WHERE promo_category = 'TV' OR promo_category ='internet'
          AND promo_end_date >='15-MAR-00' OR promo_end_date <='15-OCT-00';
C. SELECT promo_name, promo_cost
       FROM promotions
    WHERE (promo_category BETWEEN 'TV' AND 'internet')
         AND (promo_end_date IN ('15-MAR-00','15-OCT-00'));
D. SELECT promo_name, promo_cost
       FROM promotions
    WHERE (promo_category = 'TV' OR promo_category ='internet')
         AND (promo_end_date >='15-MAR-00' AND promo_end_date <='15-OCT-00');

答案：AD

二、题目翻译

查看PROMOTIONS表的结构。
使用PROMOTIONS表，现在要找出所有在15th March 00到15th October 00这一段时间内结束促销，促销类型为'TV'和'internet'的促销产品的名称和成本。
哪两个查询语句查出的是我们需要的结果？（选择两个）

三、题目解析

B选项不正确，因为AND比OR的优先级要高，所以最后的结果会不正确。
C选项不正确，因为promo_end_date IN ('15-MAR-00','15-OCT-00')不是一个时间段，而只是两个时间点。