Oracle Database Administration I — Question 20

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

Answer options

• A. The CURRENT_TIMESTAMP function returns data without time zone information
• B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
• C. A TIMESTAMP data type column contains information about year, month, and day
• 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)

Correct answer: A, D, E

Explanation

The correct answers A, D, and E are true because A states that CURRENT_TIMESTAMP does not include time zone info, while D and E accurately describe the DBTIMEZONE and SESSIONTIMEZONE functions, which return offsets from UTC. Option B is incorrect because a TIMESTAMP WITH LOCAL TIMEZONE stores the timestamp in UTC, and option C is misleading as a TIMESTAMP data type includes time details as well, not just year, month, and day.