Multiple choice technology programming languages

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

  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. INTERVAL DAY TO SECOND

  4. INTERVAL YEAR TO MONTH

  5. TIMESTAMP WITH DATABASE TIMEZONE
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

TIMESTAMP, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH are valid Oracle datetime/interval types. 'INTERVAL MONTH TO DAY' is not a valid Oracle type, and 'TIMESTAMP WITH DATABASE TIMEZONE' is also not a standard type name.

Keep practicing — related questions