what is the difference between primary key & foreign key?
Answer Posted / vasavi
primary key does not allow duplicate and null values
primary is unquie.
foreign key allows null values it refers primary key.
foreign key allows duplicate values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give syntax for SQL and ORACLE joins.
What is different types of joins?
How to use "startup" command to start default instance?
Explain rename?
What is flashback in Oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is Data Dictionary Cache in Oracle?
please explain.. DB architecture ...
Compare and contrast between sql and sql server and explain its various functions?
Is oracle the best database?
How many types of database triggers exist?
How can Oracle users be audited?
How to check the server version in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
When system tablespace is created?