Oracle Database SQL — Question 226

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

Correct answer: C, E

Explanation

Option C is correct because CURRENT_DATE does indeed return the current date and time according to the session's time zone. Option E is also correct, as CURRENT_TIMESTAMP returns the same date and time as SYSDATE but includes additional details about fractional seconds. The other options are incorrect because they either misrepresent the functionalities of SYSDATE and CURRENT_DATE or incorrectly state their limitations.