Oracle Exam 1Z0-082 Topic 15 Question 18 Discussion

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

Question #: 18
Topic #: 15

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

AThe CURRENT_TIMESTAMP function returns data without time zone information

BA TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

CA TIMESTAMP data type column contains information about year, month, and day

DThe DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

EThe SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Show Suggested Answer

Suggested Answer: B, D, E

by Annelle at May 07, 2022, 07:50 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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