Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139032 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 to delete a column in an existing table?
How to best split csv strings in oracle 9i?
What is a read write transaction in oracle?
How to use values from other tables in update statements using oracle?
Does facebook use oracle?
Point the difference between translate and replace?
What is meant by joins? List out the types of joins.
Explain overloading. Can functions be overloaded?
How to start instance with a minimal initialization parameter file?
Explain oracle data types with examples?
How to loop through a cursor variable?
How to add a new column to an existing table in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to estimate disk space needed for an export job?
How to create a table in a specific tablespace?
