Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
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 |
Explain an ORA-01555
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?
Give the stages of instance startup to a usable state where normal users may access it.
what is the difference b/w oracle8i and oracle9i
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
What is database schema?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
what are basic modules required to implement oracle application in any oraganisation?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?