Answer Posted / yuvaevergreen
Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the multi-insert?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the primary characteristics of the Teradata.
What is a three-tier data warehouse?
What are the scenarios in which full table scans occurs?
What is difference between user and database in teradata?
What are teradata utilities?
Highlight the differences between Primary Key and Primary Index.
Explain the term 'primary key' related to relational database management system?
Why does varchar occupy 2 extra bytes?
How can we check the version of Teradata that we are using currently?
Define views in teradata with syntax.
What is a sparse index?
Explain the term 'database' related to relational database management system?
What is basic teradata query language?
