what is the difference between primary key & foreign key?

Answer Posted / ramprakash

Primary keys enforce entity integrity by uniquely
identifying entity instances. Foreign keys enforce
referential integrity by completing an association between
two entities.

Is This Answer Correct ?    275 Yes 50 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between formal parameters and actual parameters?

546


Give the different types of rollback segments.

580


How to start an oracle instance?

574


How to concatenate two text values in oracle?

593


What is the dynamic sql in oracle?

598






What is the difference between postgresql and oracle?

505


What are the logical operations?

677


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1605


what is difference between sql plus and sql*plus? (not sql and sql plus).

3348


How to use values from other tables in update statements using oracle?

568


Which is better Oracle or MS SQL? Why?

3976


what is the scenario where you take the database to NoArchivelog mode?

1836


What are the different types of database objects?

527


How to open and close an explicit cursor in oracle?

578


What is oracle used for?

534