what is the difference between primary key & foreign key?
Answer Posted / shaik gouse peer
Basic difference betweeen Primary key and foreign key is :
Primary key will not allow "Null values" and "Duplicate
values"
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 130 Yes | 25 No |
Post New Answer View All Answers
What is control file used for?
What happens if you set the sga too low in oracle?
How to view the data files in the current database?
Define oracle database
what are bitmap indexes? How does they work?
How to rename an existing table?
What are the numeric comparison operations?
What is system tablespace?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to change program global area (pga) in oracle?
Who developed oracle & when?
How can I see all tables in oracle?
What is meant by a deadlock situation?
Is rowid unique in oracle?
What is meant by joins?