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

what are the day to day activities of teradata DBA ?

0 Answers   TCS,

How to view every column and the columns contained in indexes in teradata?

0 Answers  

Highlight the advantages of PPI(Partition Primary Index).

0 Answers  

Name the five phases that come under MultiLoad Utility.

0 Answers  

Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers  

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

0 Answers  

Describe primary index in teradata?

0 Answers  

can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,

what is identity column in TD?

2 Answers   Wipro,

Did you write stored procedures in teradata?

0 Answers  

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  

What is a pseudo key? What is its use???

2 Answers   Mphasis,

For more Teradata Interview Questions Click Here
Categories