nerdexam
Oracle

1Z0-071 · Question #280

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

The correct answer is 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. See the full explanation below for the reasoning.

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.

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    13% (3)
  • D
    4% (1)
  • E
    78% (18)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice