what is the difference between primary key & foreign key?

Answer Posted / simbu

primary key is a keyword .that refers to the unique value
in the particular record.it cant have null

foreign key is always keyword that refers primary key.it has
null value.its refers to another table

Is This Answer Correct ?    34 Yes 8 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?

557


Explain integrity constraint?

656


Why does Oracle not permit the use of PCTUSED with indexes?

1966


What is an oracle recycle bin?

565


What is oracle database 10g express edition?

617






How does oracle handle read consistency?

687


Explain what are the uses of rollback segment?

598


What is the use of aggregate functions in oracle?

593


Will you be able to store pictures in the database?explain.

549


What is an Oracle Instance?

701


Can we insert data in view oracle?

547


What are the most common interview questions on ETL Testing for experience?

613


How to use an explicit cursor without open statements?

628


Does oracle database need java?

535


What is the difference between a hot backup and a cold backup in oracle?

586