Multiple choice technology databases

Which of the following data types are specific only to Teradata and not compatible to ANSI.

  1. LONG VARCHAR

  2. BYTEINT

  3. DATE

  4. TIMESTAMP WITH ZONE
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Teradata-specific non-ANSI data types include LONG VARCHAR (variable-length text beyond ANSI limits), BYTEINT (1-byte integer -3 to 3), and DATE (Teradata's date format differs from ANSI standard). TIMESTAMP WITH TIME ZONE is actually ANSI-standard SQL.

Keep practicing — related questions