OCP 1Z0 051 QUESTION NO: 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/jgmydsai/article/details/26671481