Multiple choice technology databases

Which of the following are the valid datetime datatypes in Oracle (choose all that apply):

  1. TIMESTAMP WITH LOCAL TIME ZONE

  2. TIMESTAMP

  3. TIMESTAMP WITH TIME ZONE

  4. DATE
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Oracle supports several datetime datatypes, including DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. All four options represent valid built-in datetime types in Oracle SQL.

Keep practicing — related questions