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’)
A,C are identical!!
A and C are not identical, read them again.
A: WHERE promo_name NOT LIKE ‘T%’ OR promo_name NOT LIKE ‘N%’
Uses OR, so in this case will return everything including everything that starts with a “T” and an “N”
C: WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’
Uses AND, so in thus case will exclude everything starting with a “T” or “N” which is what is required by the question.
Thanks!