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

一、原题

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')不是一个时间段，而只是两个时间点。