Multiple choice technology databases

Which three are DATETIME data types that can be used when specifying column definitions? (Choose three)

  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. TIMESTAMP WITH DATABASE TIMEZONE

  4. INTERVAL YEAR TO MONTH

  5. INTERVAL DAY TO SECOND
Reveal answer Fill a bubble to check yourself
A,D,E Correct answer
Explanation

Oracle's DATETIME data types include TIMESTAMP (stores date and time), INTERVAL YEAR TO MONTH (for periods of years and months), and INTERVAL DAY TO SECOND (for periods of days, hours, minutes, seconds). Option B 'INTERVAL MONTH TO DAY' is not a valid interval type - intervals go from larger to smaller units. Option C 'TIMESTAMP WITH DATABASE TIMEZONE' is incorrect - the correct syntax is TIMESTAMP WITH DATABASE TIMEZONE or TIMESTAMP WITH TIMEZONE.

Keep practicing — related questions