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
- 4724 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 |
Why more redos are generated when the oracle database is in begin backup mode?
How to clone the database using RMAN back
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what is diff between pre insert,on insert,post insert triggers?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
You have just compiled a PL/SQL package but got errors, how would you view the errors?
What is store procedure?and how do u take the values from database and run in scripts?
What do you mean by hz_ in customer tables? : oracle accounts receivable
what is different between inline query,subquery& corelated query?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
what is difference between inner join & nested query or subqueries
What is the importance of batch source set up in ar? : oracle accounts receivable
Oracle General 
