Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137402 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 privilege is needed for a user to insert rows to tables in another schema?
How to retrieve values from data fields in record variables?
How to add a new column to an existing table in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is an oracle user role?
What is the difference between sharding and partitioning?
How to run the anonymous block again?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
IS it possible to built the oracle database without setting the kernal parameters?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How a database is related to tablespaces?
What is dynamic proxy?
What are a query and state the different types of queries and their uses?
What is the fastest query method to fetch data from the table?
What are the execution control statements?
