Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
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.
I would say: BCE
https://www.examtopics.com/discussions/oracle/view/8426-exam-1z0-071-topic-1-question-262-discussion/
I will follow BCE too.
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.
I think correction BCE. For A the time zone used is the db time zone not the client session time zone.
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.
BCE should be correct
B is false, it return only time zone name
ACE, B is false, it return only time zone name