what is the difference between primary key & foreign key?
Answer Posted / anjanareddy
i cleared this question simple.
TAKE A LOOK
primary key:-It doesn't allow NULL values and duplicate values
it is a unique one.
Foreign key:- It allows NULL and duplicate values
It always give reference to primary key of another table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is set operator oracle?
What is a user role in oracle?
How to use "if" statements on multiple conditions?
Can we write insert statement in function in oracle?
How to connect ms access to oracle servers?
What do you understand by database schema and what does it hold?
Please explain oracle left join with an example?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
is there a tool to trace queries, like profiler for sql server?
What are the ansi data types supported in oracle?
How to pass parameters to procedures?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Difference between oracle's plus (+) notation and ansi join notation?
How to retrieve the count of updated rows?
What is the recommended interval at which to run statspack snapshots, and why?