Oracle Database Administration I — Question 23

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.)

Answer options

• A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• 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
• D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Correct answer: C, F

Explanation

The correct answers are C and F because CURRENT_DATE indeed reflects the time based on the session's time zone, and CURRENT_TIMESTAMP matches the current date of CURRENT_DATE. Options A and E are incorrect as they pertain to SYSDATE's characteristics, while B and D are not accurate statements about the querying capabilities and format dependency of SYSDATE.