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

Explain an ORA-01555

2 Answers  


what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,


How would you determine the time zone under which a database was operating?

1 Answers  


Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  


How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers  


What is database schema?

4 Answers   Infosys,


Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  


what are basic modules required to implement oracle application in any oraganisation?

0 Answers  


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers   jusco,


HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 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)