AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4763

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

Option A

A.    UPDATE promotionsSET promo_cost = promo_cost+100WHERE TO_CHAR(promo_end_date,’yyyy’>’2000’;
 

Option B

B.    SELECT promo_begin_dateFROM promotionsWHERE TO_CHAR(promo_begin_date,’mon dd yy’)=’jul 01 98’;
 

Option C

C.    UPDATE promotionsSET promo_cost = promo_cost+100WHERE promo_end_date > TO_DATE(SUBSTR(’01-JAN-200’,8));
 

Option D

D.    SELECT TO_CHAR(promo_begin_date,’dd/month’)FROM promotionsWHERE promo_begin_date IN (TO_DATE(‘JUN 01 98’,TO_DATE(‘JUL 01 98’));
 

Correct Answer A,B
Explanation


Question ID 4764

See the structure of the PROGRAMS table:
Exhibit:
 
Which two SQL statements would execute successfully? (Choose two.)

Option A

A.    SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs;
 

Option B

B.    SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;
 

Option C

C.    SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing') FROM programs;
 

Option D

D.    SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),'Ongoing') FROM programs;
 

Correct Answer A,D
Explanation

Send email to admin@getfreedumps for new dumps request!!!