Oracle Exam 1Z0-082 Topic 12 Question 110 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 110
Topic #: 12

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

ACURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

BSYSDATE can be queried only from the DUAL table

CCURRENT_DATE returns the current date and time as per the session time zone

DSYSDATE can be used in expressions only if the default date format is DD-MON-RR

ESYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

FCURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Show Suggested Answer

Suggested Answer: C, E

by Talia at Jan 12, 2025, 11:32 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

17 days ago

I'm not sure about B. Can SYSDATE really only be queried from the DUAL table?

upvoted 0 times

...

23 days ago

I agree with you, Katlyn. I also believe that E is true because SYSDATE and CURRENT_DATE are based on the server's operating system.

upvoted 0 times

...

24 days ago

I think A is true because CURRENT_TIMESTAMP includes fractional seconds.

upvoted 0 times

...