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




Answers were Sorted based on User's Feedback



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

Answer / ram

Absolutly No. One table can not have more than one PK. But
u can have 2 cols as 1 PK called Composite Primary Key.

Is This Answer Correct ?    40 Yes 0 No

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

Answer / rajiv senapati

A table can't have two primary key.

Is This Answer Correct ?    23 Yes 1 No

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

Answer / ram

Primary key
============
1. A table should have only one primary key
2. More than one column can consist of a primary key – upto
64 columns
3. Can not be NULL values (missing values)
4. Should be unique values (no duplicate value)

Foreign key
============
1. A table may have zero or more than that upto 32 keys
2. More than one column can consist a primary key – upto 64
columns
3. Can have NULL values
4. Can have duplicate values
5. There should be a corresponding primary key in the
parent table to enforce referential integrity for a foreign
key

Is This Answer Correct ?    15 Yes 1 No




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

Answer / maran

No No.. it shouldnt.. One table should have only one PK.

Is This Answer Correct ?    8 Yes 1 No

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

Answer / tdguy

There can be more than one primary key in TD. But PI should
always be one and can contain upto 16 columns. Performance
of Teradata is directly linked to PI. Row hash value (32
bit) is calculated from PI using the hashing function. This
hash value along with the uniqueness id (32 bit value)
helps in locating the amp.

Is This Answer Correct ?    3 Yes 0 No

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

Answer / tdguy

Hi,
Correction to the answer mentioned above. Only one PK can
be defined for a table-not null,not duplicate. But there
can be 32 secondary indexes. Thanks Santhosh.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / lizy

please can you tell me Name at least three brands of
Database Management Systems. need it urgently thank you
very much

Is This Answer Correct ?    0 Yes 0 No

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

Answer / rajiv senapati

go through rdbms book by rajiv senapati and rajib mall

Is This Answer Correct ?    1 Yes 1 No

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

Answer / santosh kumar sarangi

Hi Tdguy, can you please tell me the syntax to create more
than one primary key for a single table.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / lizy

Is it possible to have more than one row on the same table
with the same foreign key. please help me by giveng this
answer thks

Is This Answer Correct ?    1 Yes 2 No

Post New Answer



More Teradata Interview Questions

what is the default character set in teradata,,?

2 Answers   IBM, TCS,


teradata support to automatically increase the character length or not?

1 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,


one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,


How to load specific no.of records using bteq, or fastload,or multiload

0 Answers   Infosys,






How a Referential integrity is handled in Teradata?

5 Answers  


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


What are the differences between TerdataV2R5 and V12 Versions please??

3 Answers  


how teradata fetches a row from primary index table?

1 Answers  


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

199 Answers   Cognizant, Deloitte, IBM, Syntel, Prometric,


write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,


hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  






Categories