Oracle
1Z0-071 · Question #280
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
The correct answer is E. SYSDATE can be queried only from the DUAL table. F. CURRENT_DATE returns the current date and time as per the session time zone. See the full explanation below for the reasoning.
Question
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
Options
- ACURRENT_TIMESTAMP returns the same date as CURRENT_DATE.
- BCURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of
- CSYSDATE and CURRENT_DATE return the current date and time set for the operating system of
- DSYSDATE can be used in expressions only if the default date format is DD-MON-RR.
- ESYSDATE can be queried only from the DUAL table.
- FCURRENT_DATE returns the current date and time as per the session time zone.
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- D4% (1)
- E78% (18)
Community Discussion
No community discussion yet for this question.