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?
A. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.
B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.
C. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR.
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
AF
AF
AF
It can´t be “E. SYSDATE can be queried only from the DUAL table.” no necesary SYSDATE get from dual table
AF
Should be AF
BE
AF