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
- 17591 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
Discuss the advantages of using partitioned primary index in a query?
how many modules are there in telecome domain?how to explain the architecture?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How to view every column and the columns contained in indexes in teradata?
What is the difference between teradata and basic rdbms?
In the Primary Index, what is the score of AMPs that are actively involved?
List the logical and conditional operators that are used with teradata along with their meanings?
What is spool space? Why do you get spool space errors?
Explain and compare pros and cons of start schemas?
If a Node is busy what are the steps you can take to avoid ?
What are the things to be considered while creating secondary index?
Highlight the differences between Primary Key and Primary Index.
What are the functions involved in shared information architecture?
Did you write stored procedures in teradata?
What is node? How many nodes and amps used in your previous project?
