what is the difference between primary key & foreign key?

Answer Posted / rathika

only one primary key on the table.
more than one foreign key on a table

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do a full database export?

631


is there a tool to trace queries, like profiler for sql server?

598


How to concatenate two text values in oracle?

589


What are set operators?

644


Why do you use stored procedures and state some of its disadvantages?

563






What is a sub query? Describe its types?

540


How does Oracle guarantee data integrity of data changes?

1936


How to update values on multiple rows in oracle?

596


what happened to the global index when I truncate the data in one of the partition?

1515


20. Using a set operator, display the client number of all clients who have never placed an order.

1795


What are the execution control statements?

613


Explain about your project and its relation to the current job position you are applying to?

538


How to create a new table in oracle?

589


What is primefaces used for?

558


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?

1470