OCP-1Z0-新051-61题版本-55

QUESTION NO: 55

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

Answer: A,B

答案解析：

参考：91：http://blog.csdn.net/rlhua/article/details/12071263

Explanation: