what is the difference between primary key & foreign key?
Answer Posted / altaf ali
primary key of a relation is a candidate key that has been
designated as the main key.It doesn't has null value.
A foreign key is an attribute in a relation that can be
used as a key to another relation.It allow null and
duplicate value.
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
Why does Oracle not permit the use of PCTUSED with indexes?
Explain a segment?
Can I create users through internet explorer in oracle 10g?
What are joins, explain all types of joins?
What is recovery manager(rman) backup in Oracle?
What is Library Cache in Oracle?
How to create lov dynamically at runtime & attach to text field?
What is archive log in Oracle?
How to define a cusotmer as a supplier in ORACLE R12
How to create a new tablespace in oracle?
What is query image?
Explain overloading. Can functions be overloaded?
Explain what are the type of synonyms?
what happened to the global index when I truncate the data in one of the partition?
what are steps for interface? where is exchange rate defined in which table?