what is the difference between primary key & foreign key?

Answer Posted / ibrahim

A primary key is an combination of attributes that uniquely
identifies each row in a relation. A primary key is
designated by underlining the attribute name. The primary
key of an entity set allows us to distinguish among the
various entities of the set.

A foreign key is an attribute in a relation of database
that serves as the primary key of another relation in the
same database.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is port in oracle? how is it related to database application.

1446


master table and child table performances and comparisons in Oracle ?

1674


How to install oracle odbc drivers?

633


How to filter out duplications in the returning rows using oracle?

648


Hi Can any one tell me what are the API's used in requisition import.

1502






How to drop a stored function?

683


Explain the use of compress option in exp command.

554


How to run create database statement again?

631


How to run create database statement?

585


What is bulk load in oracle?

605


What is query image?

590


What is a oracle database?

617


How do I find my oracle client driver version?

538


Is a rollback possible to any savepoint?

565


How much memory your 10g xe server is using?

588