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