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

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

0 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  


What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,


What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,


Why AMP & PE are called Vprocs?

4 Answers  






"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  


I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

197 Answers   Cognizant, Deloitte, IBM, Syntel, Prometric,


id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,


Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,


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,


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

3 Answers  


what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  






Categories