Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 8907 Views
- I also Faced
- E-Mail Answers
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
What are the different design perspectives used in teradata?
How do you set the session mode parameters in bteq?
What is teradata? What are some primary characteristics of teradata?
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 ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Differentiate database data and data warehouse data?
How many types of joins are there in teradata?
What is the purpose of joins in teradata?
What are the available join types in teradata?
Highlight the need for Performance Tuning.
What is meant by Teradata Gateway?
What are the components provided on node?
What is the use of teradata system software?
What are the functions of a teradata dba?
What is a sparse index?
