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
- 8876 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
Explain Teradata performance tuning and optimization?
What are the functions involved in shared information architecture?
What is inner join and outer join?
What are the different functions performed in development phase?
What are the uses of bynets in multi-node systems?
What is the basic syntax for teradata select statement?
Can you fastexport a field, which is primary key by putting equality on that key?
Mention a few of the ETL tools that come under Teradata.
Where is teradata rdbms used?
What are the multiload utility limitations?
What happens when a node suffers a downfall?
Explain teradata vs. Redshift?
What are the different table types that are supported by teradata?
What is smp and mpp platforms?
What is the difference between global temporary tables and volatile temporary tables?
