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 happens to indexes if you drop a table?
Explain the difference between sql and oracle?
How to convert characters to dates in oracle?
What happens to the indexes if a table is recovered?
How to view all columns in an existing table?
What are the different types of trigger and explain its various uses and functions?
What happens if variable names collide with table/column names?
How to select an oracle system id (sid)?
Can we protect our pl/sql source code?
How to loop through a cursor variable?
Explain an integrity constrains?
State and explain about oracle instance?
What is an oracle cursor variable?
What is meant by joins? List out the types of joins.
What is procedure overloading in oracle?