what is the difference between primary key & foreign key?
Answer Posted / himabindu
primary key is unique.it does not allow null&duplicate
values.it is individual.
foreign key always refers primary key.it is
independent
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to connect to a remote server?
Difference between the “verify” and “feedback” command?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the dynamic sql in oracle?
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.
Can we write dml statement in function in oracle?
How to create a single index for multiple columns?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is meant by a deadlock situation?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
State some uses of redo log files?
What do you know about normalization? Explain in detail?
what happened to the global index when I truncate the data in one of the partition?
What are the different types of partitions in oracle?