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 / rajiv senapati

yes

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does hashing happens in teradata?

624


What exactly do you know about catching in teradata?

643


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

580


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3004


How do you do backup and recovery in teradata?

553






In Teradata, what is the significance of UPSERT command?

597


When tpump is used instead of multiload?

633


What are the primary characteristics of the Teradata.

595


Describe the set operators in teradata.

583


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

634


Highlight the need for Performance Tuning.

595


Explain BYNET.

613


How to select first n records in teradata?

613


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

1321


In the Primary Index, what is the score of AMPs that are actively involved?

580