Oracle
1Z0-071 · Question #280
1Z0-071 Question #280: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #280. The question stem and answer options stay visible for context.
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 as CURRENT_DATE.
- BCURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of
- CSYSDATE and CURRENT_DATE return the current date and time set for the operating system of
- DSYSDATE can be used in expressions only if the default date format is DD-MON-RR.
- ESYSDATE can be queried only from the DUAL table.
- FCURRENT_DATE returns the current date and time as per the session time zone.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.