Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139115 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gaurav , ashish ,preeti , main
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 ? | 57 Yes | 16 No |
Post New Answer View All Answers
What is execute immediate in oracle?
How do I learn what codesets are available in oracle?
How to revoke create session privilege from a user in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
In what script is snap$ created? In what script is the scott/tiger schema created?
What is the fastest query method to fetch data from the table?
What is the difference between hot backup and cold backup in oracle?
How to get execution statistics reports on query statements?
Briefly explain what is literal? Give an example where it can be used?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Name the various constraints used in oracle?
How to retrieve data from an explicit cursor?
How different is ms access and oracle?
How to write text literals in oracle?
How can I introduce multiple conditions in like operator?
