what is the difference between primary key & foreign key?
- 57 Answers
- 122466 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mathiyarasan
Primary is unique one. Each table has only one primary key.
But not allow null values.
Foreign key is opposite of primary. It is reference of
primary key from another table. It allow Null value. Each
table can have more than one foreign key.
Foreign key is used to link one to another table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Post New Answer View All Answers
How different is ms access and oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Compare and contrast between sql and sql server and explain its various functions?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
ABOUT IDENTITY?
What is bulk collect in oracle?
Explain an extent?
Will you be able to store pictures in the database?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Give the advantages and disadvantages of clusters.
What is difference between truncate and delete?
How many file formats are supported to export data?
Why does for update in oracle 8 cause an ora-01002 error?
What is recovery manager(rman) backup in Oracle?
