Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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.

Question Posted / subhakanta.senapati

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

List out all forms of LOCKS that are available in Teradata.

0 Answers  

Name the five phases that come under MultiLoad Utility.

0 Answers  

wt r before journal& after journel.....in teradata

4 Answers  

how teradata fetches a row from primary index table?

1 Answers  

plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,

I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,

How do you do backup and recovery in teradata?

0 Answers  

Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,

How do you Generate Sequence in Teradata?

3 Answers   TCS,

What is partitioned primary index (ppi)?

0 Answers  

Explain the term 'columns' related to relational database management system?

0 Answers  

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,

For more Teradata Interview Questions Click Here
Categories