Oracle
1Z0-071 · Question #421
In your session, the NLS_DATE_FORMAT is DD-MM-YYYY. There are 86400 seconds in a day. Examine this result: DATE ----------- 02-JAN-2020 Which statement returns this?
The correct answer is A. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4'. See the full explanation below for the reasoning.
Question
In your session, the NLS_DATE_FORMAT is DD-MM-YYYY. There are 86400 seconds in a day. Examine this result:
DATE ----------- 02-JAN-2020 Which statement returns this?
Options
- ASELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4'
- BSELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7'
- CSELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5'
- DSELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5'
- ESELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6'
How the community answered
(22 responses)- A82% (18)
- B5% (1)
- D5% (1)
- E9% (2)
Community Discussion
No community discussion yet for this question.