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 and INTERVAL types (DAY TO SECOND, YEAR TO MONTH) are valid SQL datetime data types for column definitions. INTERVAL MONTH TO DAY is not a valid interval type (should be INTERVAL DAY TO MONTH), and TIMESTAMP WITH DATABASE TIMEZONE is incorrect syntax.

Keep practicing — related questions