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

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Walker

1 months ago

I heard someone tried to use SYSDATE in a SQL query, but the database kept returning 'Time is an illusion. Lunchtime doubly so.'

upvoted 0 times

Corrina

1 days ago

E) SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

upvoted 0 times

...

Ernest

14 days ago

A) CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

upvoted 0 times

...

Tesha

1 months ago

F is just redundant with C, right? Why would they include that as a separate option?

upvoted 0 times

Santos

6 days ago

C) CURRENT_DATE returns the current date and time as per the session time zone

upvoted 0 times

...

Lottie

12 days ago

B) SYSDATE can be queried only from the DUAL table

upvoted 0 times

...

Marylin

17 days ago

A) CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

upvoted 0 times

...

Melita

2 months ago

E is interesting, but I'm pretty sure SYSDATE and CURRENT_DATE are based on the database server's time, not the operating system's.

upvoted 0 times

...

Latrice

2 months ago

I think D is definitely false. The date format doesn't affect the use of SYSDATE in expressions.

upvoted 0 times

...

Zachary

2 months ago

A and C seem correct, but I'm not sure about the fractional seconds part in A. I'll have to double-check the documentation on that.

upvoted 0 times

Elliot

13 days ago

You're right, A and C are the correct statements about date/time functions in that session.

upvoted 0 times

...

Michael

25 days ago

Yes, A is correct. And C is also true because CURRENT_DATE returns the current date and time according to the session time zone.

upvoted 0 times

...

Yen

1 months ago

I think A is correct because CURRENT_TIMESTAMP does include fractional seconds.

upvoted 0 times

...

Junita

2 months ago

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

upvoted 0 times

...

Ernestine

2 months 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

...

Katlyn

2 months ago

I think A is true because CURRENT_TIMESTAMP includes fractional seconds.

upvoted 0 times

...