Oracle
1Z0-082 · Question #127
In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR. h two statements are true about expressions using PROMO_BEGIN_DATE contained In a…
The correct answer is C. PROMO_ BEGIN_DATE - sysdate will return an error. D. PROMO_ BEGIN_DATE - 5 will return a date. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR. h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?
Options
- Ato_numberipromo_begin_date) - s will return a number.
- BPROMO_ BEGIN_DATE - sysdate will return a number.
- CPROMO_ BEGIN_DATE - sysdate will return an error.
- DPROMO_ BEGIN_DATE - 5 will return a date.
- ETO_date(PROMO_ BEGIN_DATE * 5| will return a date.
How the community answered
(30 responses)- A3% (1)
- B10% (3)
- C83% (25)
- E3% (1)
Topics
#date arithmetic#SYSDATE#TO_DATE#data type operations
Community Discussion
No community discussion yet for this question.