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.
Answers were Sorted based on User's Feedback
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 |
How can bottlenecks be identified?
Why do Hash joins usually perform better than Merge Joins?
What is teradata? Also, list out some of the primary characteristics of teradata.
Find 2 highest sal from each dept who have completed 5 year in org
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the command in bteq to check for session settings ?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What are the different functions performed in development phase?
What are the joins in teradata and how many types of joins are there in teradata?
What are the various indexes in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the difference between fastload and multiload? Which one is faster?