Multiple choice technology databases

Pick the two statements that are true regarding Identity Columns. (Select 2)

  1. They don't have to be a Primary Index column

  2. They are not allowed to be a Primary Index column.

  3. They are required to be a Non-Unique Primary Index

  4. You can only specify one Identity Column per table.
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

Identity columns in Teradata are independent of the Primary Index - they can be defined on non-PI columns. They are also allowed to be part of the PI, contradicting option B. Teradata enforces a strict limit of one identity column per table to maintain data integrity and avoid ambiguity in auto-generation.

Keep practicing — related questions