Oracle
1Z0-082 · Question #51
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 B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session time zone. See the full explanation below for the reasoning.
SQL and PL/SQL
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 and time as SYSDATE with additional details of
- BSYSDATE can be queried only from the DUAL table
- CCURRENT_DATE returns the current date and time as per the session time zone
- DSYSDATE can be used in expressions only if the default date format is DD-MON-RR
- ESYSDATE and CURRENT_DATE return the current date and time set for the operating system of
- FCURRENT_TIMESTAMP returns the same date as CURRENT_DATE
How the community answered
(25 responses)- A4% (1)
- B76% (19)
- D8% (2)
- F12% (3)
Topics
#SYSDATE#CURRENT_DATE#CURRENT_TIMESTAMP#NLS_DATE_FORMAT
Community Discussion
No community discussion yet for this question.