OCP-1Z0-051 第61题 where通配符

一、原题

View the Exhibit and examine the structure of the PROMOTIONS table.
You need to generate a report of all promos from the PROMOTIONS table based on the following conditions:
1. The promo name should not begin with 'T' or 'N'.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Which WHERE clause would give the required result?


A. WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%'
          AND promo_cost > 20000
          AND promo_end_date > '1-JAN-01'

B. WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')
            OR promo_cost > 20000 
            OR promo_end_date > '1-JAN-01'

C. WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%'
          AND promo_cost > 20000
          AND promo_end_date > '1-JAN-01'

D. WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%')
          AND (promo_cost > 20000 AND promo_end_date > '1-JAN-01')

答案：C

二、题目翻译

查看PROMOTIONS表结构
要从PROMOTIONS表获取所有promos的报表，基于如下的条件：
1.promo name不是以'T’或'N'开头。
2.promo的成本大于$20000。
3.在2001年1月1日之后结束的promo。
哪个WHERE子句能给出所需结果？

三、题目解析

A选项不正确，AND的优先级大于OR，会导致结果不正确。
B选项不正确，三个条件是并且(AND)关系，而不是或者(OR)。
D选项不正确，不是T或N开头，只是包含有T或N。