Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?



Why we are using primary key and foreign key in oracle and difference between primary key and forei..

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

Post New Answer

More Oracle AllOther Interview Questions

can we use lexical perameter in oracle plsql if yes how

0 Answers  


can we drop dual table

7 Answers   Metric Stream,


What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,


i have marks in table,how to find total?

1 Answers  


Differentiate between transaction type and transaction source? : oracle accounts receivable

0 Answers  


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.

0 Answers  


How can you enable a trace for a session?

2 Answers  


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  


What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,


How many segment are present in Oracle Manufacturing

0 Answers   Oracle,


what are the tools used for oracle 10g in real time.

0 Answers   IBM,


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

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)