what is primary key and foreign key when and where have to use

Answer Posted / csprusty

To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add a new column to an existing table with a default value?

548


What happens to indexes if you drop a table?

701


How different is ms access and oracle?

547


How will you identify oracle database software release?

527


How to assign query results to variables?

594






Why should I use oracle database?

575


What is merge in oracle?

562


What is truncate oracle?

534


Explain drop constraint oracle?

593


Explain what are clusters?

616


What is the implicit cursor in oracle?

570


Explain the use of tables option in exp command.

595


What is Undo Management Advisor in Oracle?

614


What are the uses of linked server and explain it in detail?

588


Explain what are synonyms used for?

611