Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17782 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many tables can you join in v2r5?
What are types of partition primary index (ppi) in teradata?
Which is faster fastload or multiload?
Explain BYNET.
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the purpose of indexes?
What are the steps involved after the disk manager passes the request?
How you will check the version of teradata?
List out all forms of LOCKS that are available in Teradata.
What are the available join types in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the primary index in teradata?
Explain and compare pros and cons of snow flake schemas?
any one answer me how they can analyzing the project using data ware housing?
Can you fastexport a field, which is primary key by putting equality on that key?
