Interested to Buy Any Domain ? << Click Here >> for more details...
Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
- 1 Answers
- 4831 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramachandra
we are using primary key and foreign key database designer identify an entity
diffencee b/w primary key and foreign key
1.every table should have one primary key
but foreign key it doesnt any rule we keep more than one foreign key
2.primary key doesn't accept null values
3primary key is parent key
but foreign key is child key it depends only primary key table or column it doesn't allow more than primary key column attributes.
4.primary key doesn't accept duplicate values
but foreign key accepting duplicate values
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What view would you use to determine free space in a tablespace?
can u give guidance abt packages of plsql
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
What do you mean by Oracle MEDIA RECOVERY?
what are basic modules required to implement oracle application in any oraganisation?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
3. Steps in UAT?
Explain the process of recievables in oracle financials. : oracle accounts receivable
What is the mandatory setup in cyclecount ?
8. Supporting AP, AR and GL?
what is semphore explian it?
what are the API of GL,PO,AP
