Tera Data Interview Questions and Answers

Related Subjects

All Subject

My SQL Interview Questions and Answers | MS SQL Interview Questions and Answers | Oracle Interview Questions and Answers | MongoDB Interview Questions and Answers | Neo4J Interview Questions and Answers | Cosmos DB Interview Questions and Answers | Data Warehouse Interview Questions and Answers | DBMS Interview Questions and Answers

Question - Difference between PRIMARY KEY Constraints Versus UNIQUE Constraints in Teradata?

Answer -

UNIQUE and PRIMARY KEY constraints can only be defined on a column set that is also constrained to be NOT NULL.
To create a composite, or multicolumn, the primary key for a table, you must specify the PRIMARY KEY constraint at the table level, not the column level.
Both UNIQUE and PRIMARY KEY constraints can be defined on a UDT column.
Teradata Database also supports the related constraints UNIQUE INDEX and UNIQUE PRIMARY INDEX.

Comment(S)

Show all Coment

Leave a Comment

|

NCERT Solutions

Share your email for latest updates

Name:

Email:

Latest News

10000+ interview questions in different categories

Freshers and experienced

Testimonial

NCERT Questions Answers

We are group of professionals with the same objective for helping school students who are struggling in NCERT Questions Answers. We are just sharing our knowledge for the students and helping them by providing Questions Answers.

Halpura.com

At Halpura we are reimagining the actual potentials of quality information resources reaching people across the globe to make an everlasting impact.

Our partners