Q128 Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
- (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)
Answer: C,D,E