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
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 |
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 ? | 16 Yes | 1 No |
Answer / maran
No No.. it shouldnt.. One table should have only one PK.
Is This Answer Correct ? | 8 Yes | 1 No |
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 |
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 |
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 |
Answer / rajiv senapati
go through rdbms book by rajiv senapati and rajib mall
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
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 |
What are the functions involved in shared information architecture?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
What is Join Index in TD and How it works?
how can i answer for question like teradat architecture in interveiw
List out all forms of LOCKS that are available in Teradata.
Explain the term 'foreign key' related to relational database management system?
which join mostly use in realtime?
What is FILLER command in Teradata?
What are the different functions included in the server software?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
Highlight the differences between Primary Key and Primary Index.
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?