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
- 4746 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
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is the mandatory setup in cyclecount ?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Explain the use of table functions.
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What is db_recovery_file_dest in oracle? When do you need to set this value?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
How do you create a credit note against an invoice? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
what is semphore explian it?
