what is the difference between primary key & foreign key?
- 57 Answers
- 122289 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / anand
Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to change user password in oracle?
How to add a new column to an existing table with a default value?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
what is IDE,DMV in sql server?
Explain the dml?
Can a parameter be passed to a cursor?
What are the execution control statements in oracle?
How to select an oracle system id (sid)?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is reindexing?
What is the best way to do multi-row insert in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is an oracle cursor variable?
