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