what is the difference between primary key & foreign key?

Answer Posted / suneel manne

Primary key is a key it will allow only Unique values and
avoid duplicate values and foreign key is a reference key
from the other table, So here primary key acts as a parent
key and foreign key acts as a child key.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is better Oracle or MS SQL? Why?

5444


What are the uses of synonyms?

609


Explain the use of online redo log files in oracle.

589


Explain a synonym?

608


What is a partition in oracle?

547






What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

620


What is the parameter mode that can be passed to a procedure?

576


Explain integrity constraint?

646


How to convert character types to numeric types?

578


What is Trigger in Oracle?

575


What is primefaces used for?

559


How to define an anonymous block?

620


How a tablespace is related to data files?

583


Explain enable novalidate constraint.

599


What happens if the update subquery returns multiple rows?

614