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



IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CON..

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

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CON..

Answer / rajiv senapati

yes

Is This Answer Correct ?    2 Yes 0 No

Post New Answer




More Teradata Interview Questions

What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


Aborted in Phase 2 data acquistion completed in fastload?

2 Answers  


While creating table my dba has fallback or no fallback in his ddl. What is that?

0 Answers  


What are the various etl tools in the market?

0 Answers  


Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,






what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,


What are the primary characteristics of the Teradata.

0 Answers  


Give some points about Teradata Viewpoint ?

3 Answers   Teradata,


what is identity column in TD?

2 Answers   Wipro,


How many codd's rules are satisfied by teradata database?

0 Answers  


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????

3 Answers   Mphasis,


What is a level of granularity of a fact table?

0 Answers  






Categories