READ Free Dumps For Oracle- 1z1-051
Question ID 4763 | You work as a database administrator at ABC.com. You study the exhibit carefully. |
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 |
Question ID 4764 | See the structure of the PROGRAMS table: |
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 |