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
- 4723 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
How would you determine who has added a row to a table?
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 TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
where the dff data will be stored
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is the difference between recovery and restoring of the oracle database?
What are different types of transactions in ar? : oracle accounts receivable
what is semphore explian it?
