Oracle Database SQL — Question 94

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

Answer options

• A. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
• B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
• C. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
• D. The CURRENT_TIMESTAMP function returns data without time zone information.
• E. A TIMESTAMP data type column contains information about year, month, and day.

Correct answer: B, C, E

Explanation

Option B is correct because the SESSIONTIMEZONE function indeed returns the time zone offset from UTC for the session. Option C is also correct as the DBTIMEZONE function returns the database's time zone offset from UTC. Option E is correct, indicating that the TIMESTAMP data type stores year, month, and day information, while options A and D are incorrect regarding how the timestamp data is stored and the information it includes.