Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 212

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

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

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

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

The CURRENT_TIMESTAMP function returns data without time zone information.

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

Correct Answer: B, C, E

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC), making option B true. The DBTIMEZONE function can also return an offset from Universal Coordinated Time (UTC), making option C true. A TIMESTAMP data type column contains information about the year, month, and day, making option E true. Hence, the correct selection is B, C, and E.

Discussion

OrakolOptions: BCE

I would say: BCE

McromeoOptions: AC

ACE, B is false, it return only time zone name

lucemqyOptions: BCE

BCE should be correct

Mcromeo

B is false, it return only time zone name

jm9999Options: ABC

To test A, I inserted rows from 2 different session time zones into a table using sysdate. The individual session time zones for each user session were recorded in the different rows. E is confusing because while true, that is not the only data that is recorded.

jm9999

I think correction BCE. For A the time zone used is the db time zone not the client session time zone.

Misi_Oracle

Time zone stored is based on the db time zone and will follow the time zone of the user the query it. Meaning A is wrong.

WingLOptions: BCE

I will follow BCE too.

CMjerOptions: BCE

https://www.examtopics.com/discussions/oracle/view/8426-exam-1z0-071-topic-1-question-262-discussion/