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 Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,


How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  


Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,


What is the process to restart the multiload if it fails?

7 Answers  


what is single value and Multivalue ?

1 Answers   IBM, Wipro,






teradata support to automatically increase the character length or not?

1 Answers  


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

0 Answers  


Does SDLC changes when you use Teradata instead of Oracle?

2 Answers  


what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,


what is identity column in TD?

2 Answers   Wipro,


What are the differences between TerdataV2R5 and V12 Versions please??

3 Answers  


IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  






Categories