Oracle Exam 1Z0-071 Topic 8 Question 17 Discussion

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

Question #: 17
Topic #: 8

[All 1Z0-071 Questions]

Examine these statements which execute successfully:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYY HH24 :MT:SS;'

ALTER SESSION SET TIME-ZONE = '-5:00;:

Examine the result:

If LOCALTIMESTAMP was selected at the same time, what would it return?

A11-JUL-2019 6.00.00.00000000 AM

B11-JUL-2019 11.00.00.00000000 AM

C11-JUL_2019 6.00.00.00000000 AM -05:00

D11-JUL_2019 11.00.00.00000000 AM -05:00

Show Suggested Answer

Suggested Answer: A

by An at May 09, 2022, 08:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!