Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
- 1 Answers
- 4010 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Name two files used for network connection to a database.
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
as a technical developer in oracle applications which type errors feced in your experience sofar
what is shared memory?
what is domain in database and its benefits?
i have marks in table,how to find total?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
Describe the P2P cycle ?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Give two examples of how you might determine the structure of the table DEPT.
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
Oracle General 
