what is the difference between primary key & foreign key?
- 57 Answers
- 122257 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bharathi sundar
A PRIMARY KEY DOES NOT ACCEDES DUPLICATIONS .
A FOREIGN KEY IS USED FOR LINKING TWO DATABASE TABLES
ABSTRUSELY .
A FOREIGN KEY USES THE PRIMARY KEY IN ANOTHER TABLE,
TO RETRIEVE OR TO IDENTIFY THE CELL VALUES IN ANOTHER
TABLE.........
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What would you do with an in-doubt distributed transaction?
query optmization techniques and quwry analyser+projects+ppts
How to drop a stored function?
candidate key is subset of super key but not vice-verse explain
Differentiate between function and procedure in oracle.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What do you mean by a tablespace?
What are the limitations oracle database 10g xe?
How to install oracle odbc drivers?
Write a syntax for update query in oracle?
What is a package ? What are the advantages of package ?
How to calculate date and time differences in oracle?
How to create a new table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the oracle implicit cursor?
