Oracle
1Z0-071 · Question #302
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…
The correct answer is B. PROMO_BEGIN_DATE ?SYSDATE will return a number. D. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date. See the full explanation below for the reasoning.
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.
How the community answered
(57 responses)- A2% (1)
- B81% (46)
- C12% (7)
- E5% (3)
Community Discussion
No community discussion yet for this question.