what is the difference between primary key & foreign key?
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
Can we write dml statement in function in oracle?
Why do we use bulk collect in oracle?
What is tns entry?
what is port in oracle? how is it related to database application.
Explain the use of show option in imp command.
What is redo log?
How to add a new column to an existing table in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What is a table in oracle?
What is primefaces used for?
Explain the types of exception?
Explain database link?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What would you do with an in-doubt distributed transaction?
What is the difference between primary key and unique key and foreign key in oracle?