what is the difference between primary key & foreign key?

Answer Posted / guest

primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.

whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.

Is This Answer Correct ?    155 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a data segment?

646


What are the restrictions on external table columns?

545


What is the difference between pre-select and pre-query?

619


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1268


What is data block in Oracle?

615






How to use subqueries in the from clause in oracle?

579


Explain the importance of .pll extension in oracle?

551


How to establish administrator authentication to the server?

556


What are oracle functions?

551


Explain the different normalization forms?

587


Explain the dml?

590


What is data file?

612


How do you find current date and time in oracle?

586


What are the execution control statements in oracle?

600


How do I limit the number of oracle database connections generated by weblogic server?

543