Which two SQL statements would execute successfully?

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:
Which two SQL statements would execute successfully? (Choose two.)

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:
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’));



Leave a Reply 1

Your email address will not be published. Required fields are marked *