OCP 1Z0 051 56

来源：互联网发布：手机比价软件编辑：程序博客网时间：2024/05/21 17:49

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');

between取区间数据,in取枚举信息 c错
and 比or 优先级高,且promo_end_date条件不对 b错

SQL> alter session set nls_date_language = american;Session alteredSQL> SELECT *  2    FROM (SELECT promo_name, promo_cost, promo_end_date, promo_category  3            FROM sh.promotions  4           WHERE promo_category = 'TV'  5              OR promo_category = 'internet'  6             AND promo_end_date >= '15-MAR-00'  7              OR promo_end_date <= '15-OCT-00')  8   WHERE rownum <= 5;PROMO_NAME                       PROMO_COST PROMO_END_DATE PROMO_CATEGORY------------------------------ ------------ -------------- ------------------------------post promotion #20-232               300.00 1998-11-25     postnewspaper promotion #16-349          400.00 1998-9-10      newspaperinternet promotion #14-471           600.00 2000-3-26      internetTV promotion #13-448                1100.00 2000-9-6       TVinternet promotion #25-86           1400.00 1998-11-20     internet5 rows selected

应改为

SQL> SELECT *  2    FROM (SELECT promo_name, promo_cost, promo_end_date, promo_category  3            FROM sh.promotions  4           WHERE (promo_category = 'TV' OR promo_category = 'internet')  5             AND (promo_end_date >= '15-MAR-00' AND  6                 promo_end_date <= '15-OCT-00'))  7   WHERE rownum <= 5;PROMO_NAME                       PROMO_COST PROMO_END_DATE PROMO_CATEGORY------------------------------ ------------ -------------- ------------------------------internet promotion #14-471           600.00 2000-3-26      internetTV promotion #13-448                1100.00 2000-9-6       TVTV promotion #12-49                 1500.00 2000-9-10      TVTV promotion #13-224                5200.00 2000-9-2       TVinternet promotion #29-91           6600.00 2000-9-3       internet5 rows selectedExecuted in 0.031 seconds

Answer: AD

0 0