what is the difference between primary key & foreign key?
Answer Posted / raghu
In the context of relational databases, a foreign key is a
referential constraint between two tables.[1] The foreign
key identifies a column or a set of columns in one
(referencing) table that refers to a column or set of
columns in another (referenced) table. The columns in the
referencing table must form a primary key or unique key.
| Is This Answer Correct ? | 58 Yes | 20 No |
Post New Answer View All Answers
What is a package ? What are the advantages of package ?
What is the scope of a local variable?
How to connect the oracle server as sysdba?
Explain what are the different type of segments?
How to start a specific oracle instance?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Explain oracle instance.
How can you use check constraints for self referential integrity?
What is object data modeling?
How to use "for" statements in oracle?
Why do we use coalesce function in oracle?
What is a tns file?
6. Display the client name and order date for all orders using the traditional method.
Differentiate between pre-select and pre-query?
What is the use of file param in imp command?