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. 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 standard datetime and interval data types supported in SQL for column definitions.

Keep practicing — related questions