Oracle Database SQL — Question 63

Which two statements are true about CURRENT_TIMESTAMP? (Choose two.)

Answer options

• A. The value varies depending on the setting of SESSIONTIMEZONE.
• B. It returns a value of data type TIMESTAMP.
• C. The date is in the time zone of DBTIMEZONE.
• D. It returns the same date as CURRENT_TIME.
• E. The time is in the time zone of DBTIMEZONE.
• F. It always returns the same value as SYSTEMTIMESTAMP.

Correct answer: A, B

Explanation

Option A is correct because CURRENT_TIMESTAMP is affected by the SESSIONTIMEZONE setting, which alters its output based on the session's time zone. Option B is also correct as CURRENT_TIMESTAMP indeed returns a value of the TIMESTAMP data type. The other options are incorrect because they either misrepresent the time zone association or the relationship with other timestamp functions.