what is the difference between primary key & foreign key?

Answer Posted / leang heng

Primary Key is a column or group of columns that determine
in each Record to make not null.

Foreign Key is Column that provide Relationship to Primary
Key between Entities or Table.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load data through external tables?

581


What is the database name in oracle?

534


Why is oracle database so popular?

564


How to assign values to data fields in record variables?

581


What is the meaning of recursive hints in oracle?

531






Can we call procedure inside function in oracle?

604


How to load a large xml file?

580


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1179


Explain the use of indexes option in exp command.

590


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1564


what are bitmap indexes? How does they work?

1716


What are the differences between char and nchar in oracle?

594


What is a sub query and what are the different types of subqueries?

621


Use of an integrity constraint is better to validate data. Explain

543


Can multiple cursors being opened at the same time?

612