OCP 1Z0 051 61
61. View the Exhibit and examine the structure of the PROMOTIONS table.YouneedtogenerateareportofallpromosfromthePROMOTIONStablebasedonthefollowing
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%')ORpromo_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 NOTLIKE'%T%' ORpromo_name NOTLIKE'%N%')AND(promo_cost>
20000 AND promo_end_date > '1-JAN-01')
这是个逻辑问题，可以说与sql语句无关，搞懂逻辑就可以了
(名字不起T开头 并且 不以 N开头) 并且 cost 大于 20000 并且 时间大于 1-JAN-01'
Answer: C 版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]