what is the difference between primary key & foreign key?
Answer Posted / suneel manne
Primary key is a key it will allow only Unique values and
avoid duplicate values and foreign key is a reference key
from the other table, So here primary key acts as a parent
key and foreign key acts as a child key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is query image?
What are the ways tablespaces can be managed and how do they differ?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are the data types in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to get maxsal , minsal, ename department wise in single query
ABOUT IDENTITY?
How to use an explicit cursor without open statements?
what is the difference between substr and instr function in oracle?
What is a user role in oracle?
What is a trace file and how is it created in oracle?
What is a package in oracle?
What is a sub query? What are its various types?
How do I start tns listener?
Please explain oracle data types with examples?