Which two SQL statements would execute successfully? (Choose two.)
A. UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE TO_CHAR(promo_end_date, ‘yyyy’) > ‘2000’;
B. SELECT promo_begin_date FROM promotions WHERE TO_CHAR(promo_begin_date,’mon dd yy’)=’jul 01 98′;
C. UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE promo_end_date > TO_DATE(SUBSTR(’01-JAN-2000′,8));
D. SELECT TO_CHAR(promo_begin_date,’dd/month’) FROM promotions WHERE promo_begin_date IN (TO_DATE(‘JUN 01 98’), TO_DATE(‘JUL 01 98’));
Answer:A
Which two SQL statements would execute successfully? (Choose two.)
A. UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE TO_CHAR(promo_end_date, ‘yyyy’) > ‘2000’; B. SELECT promo_begin_date FROM promotions WHERE TO_CHAR(promo_begin_date,’mon dd yy’)=’jul 01 98′; C. UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE promo_end_date > TO_DATE(SUBSTR(’01-JAN-2000′,8)); D. SELECT TO_CHAR(promo_begin_date,’dd/month’) FROM promotions WHERE promo_begin_date IN (TO_DATE(‘JUN 01 98’), TO_DATE(‘JUL 01 98’));