Oracle
1Z0-082 · Question #16
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
The correct answer is A. The CURRENT_TIMESTAMP function returns data without time zone information D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC). See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
Options
- 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
- 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)
How the community answered
(20 responses)- A85% (17)
- B10% (2)
- C5% (1)
Topics
#TIMESTAMP#time zones#DBTIMEZONE#SESSIONTIMEZONE
Community Discussion
No community discussion yet for this question.