Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Oracle Exam 1Z0-082 Topic 12 Question 110 Discussion

Actual exam question for Oracle's 1Z0-082 exam
Question #: 110
Topic #: 12
[All 1Z0-082 Questions]

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

Show Suggested Answer Hide 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
Ernest
7 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
Lottie
5 days ago
B) SYSDATE can be queried only from the DUAL table
upvoted 0 times
...
Marylin
10 days ago
A) CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
upvoted 0 times
...
...
Melita
1 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
1 months ago
I think D is definitely false. The date format doesn't affect the use of SYSDATE in expressions.
upvoted 0 times
...
Zachary
1 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
6 days ago
You're right, A and C are the correct statements about date/time functions in that session.
upvoted 0 times
...
Michael
18 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
...

Save Cancel