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.
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|
Answer / rajiv senapati
|Is This Answer Correct ?||2 Yes||0 No|
What type of indexing mechanism do we need to use for a typical data warehouse?
Aborted in Phase 2 data acquistion completed in fastload?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the various etl tools in the market?
Diff b/w v2r5 and v2r6 ?
what is the structure of UV table in MLOAD?
What are the primary characteristics of the Teradata.
Give some points about Teradata Viewpoint ?
what is identity column in TD?
How many codd's rules are satisfied by teradata database?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
What is a level of granularity of a fact table?