what is the difference between primary key & foreign key?
- 57 Answers
- 122639 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
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 raw datatype in oracle?
Difference between hot backup vs. Cold backup?
Does oracle partitioning improve performance?
What is the difference between PFILE and SPFILE in Oracle?
how to join query for one source type is oracle another source type is sql server ?
How do I find my oracle client driver version?
What happens if you use a wrong connect identifier?
How to run create database statement again?
What to do if the binary spfile is wrong for the default instance?
Explain integrity constraints?
What are the predefined tablespaces in a database?
Give the constructs of a package, function or a procedure.
what is port in oracle? how is it related to database application.
Explain constraining triggers.
How to grant create session privilege to a user in oracle?
