IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNI

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.

Question Posted / subhakanta.senapati

2 Answers
8165 Views
I also Faced
E-Mail Answers

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

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers

where we can use the delimiter in mload? pls let me know

2 Answers Wipro,

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers CTS, TCS,

What is the function of parser component in teradata?

0 Answers

What is partitioned primary index (ppi)?

0 Answers

What are the main components of teradata system?

0 Answers

Describe primary index in teradata. And what are the available primary index types?

0 Answers

what is the difference between start schma and Fsldm?

5 Answers Intel,

what are the file sizes in your project?