IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN
ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES
HOW?PLZ GIVE ME A EXAMPLE.




Answers were Sorted based on User's Feedback



IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CON..

Answer / oceanblue

Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.

e.g.

A Salary Table will have employee ID as primary key. The
table also contains TAX-ID which can not be null or duplicate.

Is This Answer Correct ?    7 Yes 0 No

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CON..

Answer / rajiv senapati

yes

Is This Answer Correct ?    2 Yes 0 No

Post New Answer




More Teradata Interview Questions

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,


How many macros we can create inside a macro

1 Answers   Wipro,


I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,


Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  


How to load specific no.of records using bteq, or fastload,or multiload

0 Answers   Infosys,






Why Fload doesn’t support multiset table?

8 Answers  


Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,


How do you eliminate duplicates?

3 Answers  


How does indexing improve query performance?

4 Answers   Satyam,


Give some points about Teradata Viewpoint ?

3 Answers   Teradata,


any one answer me how they can analyzing the project using data ware housing?

0 Answers  


Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 Answers  






Categories