Differentiate Primary Key And Partition Key?

1.	Differentiate Primary Key And Partition Key?
Answer» Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a PART of Primary Key. There are several METHODS of partition like HASH, DB2, and Random ETC. While using Hash partition we SPECIFY the Partition Key. Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, and Random etc. While using Hash partition we specify the Partition Key.

Answer»

Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a PART of Primary Key. There are several METHODS of partition like HASH, DB2, and Random ETC. While using Hash partition we SPECIFY the Partition Key.

Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, and Random etc. While using Hash partition we specify the Partition Key.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Basic Rules That Define How Pi Is Defined In Teradata?
What Is A Common Data Source For The Central Enterprise Data Warehouse?
What Are The Enhanced Features In Teradata V2r5 And V2r6?
What Is An Optimization And Performance Tuning And How Does It Really Work In Practical Projects?
Teradata Performance Tuning And Optimization?
Can We Load A Multi Set Table Using Mload?
Can I Use "drop" Statement In The Utility "fload"?
In A Table Can We Use Primary Key In One Column And In Another Column Both Unique And Not Null Constrains.if Yes How?
What Are The Types Of Tables In Teradata ?
Can You Recover The Password Of A User In Teradata?