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
- 8792 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
How to find duplicates in a table?
Mention a few of the ETL tools that come under Teradata.
How many tables can you join in v2r5?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Highlight all the modes that are present under Confidence Level.
Explain the term 'tables' related to relational database management system?
What are normalization, first normal form, second normal form and third normal form?
What are some commonly used bteq scripts?
What does Amp contain and what are all the operations that it performs?
What are the components provided on node?
What are the primary characteristics of the Teradata.
How many sessions of MAX is PE capable of handling at a particular time?
What tools would you use for that?
How do you define Teradata?
Explain and compare pros and cons of start schemas?
