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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of teradata?

574


What are the multiload utility limitations?

567


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

654


What does Amp contain and what are all the operations that it performs?

561


How to find duplicates in a table?

585






tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

350


What are the different functions included in the server software?

578


What is meant by a Virtual Disk?

555


What is the purpose of using case expression in teradata?

551


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

630


How many tables can you join in v2r5?

596


What is smp and mpp platforms?

504


Did you write stored procedures in teradata?

594


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2324


Can we collect statistics on multiple columns?

542