Oracle
1Z0-071 · Question #302
1Z0-071 Question #302: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #302. The question stem and answer options stay visible for context.
Question
In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about expressions using PROMO_BEGIN_DATE contained a query? (Choose two.)
Options
- APROMO_BEGIN_DATE ?5 will return a date.
- BPROMO_BEGIN_DATE ?SYSDATE will return a number.
- CTO_NUMBER(PROMO_BEGIN_DATE) ?5 will return a number.
- DTO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
- EPROMO_BEGIN_DATE ?SYSDATE will return an error.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.