primary key does not allow duplicate and null values but foreign key allow

what is the difference between primary key & foreign key?

Question Posted / harish

Answer Posted / harish

primary key does not allow duplicate and null values
but foreign key allows null values it refers primary key

Is This Answer Correct ?

25 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How do I start tns listener?

1046

How to delete a column in an existing table?

1076

How to count duplicated values in a column in oracle?

1044

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

2044

What is the best way to do multi-row insert in oracle?

1067

Explain the use of rows option in imp command.

1087

What are the differences between char and nchar in oracle?

1096

How to write date and time literals in oracle?

1002

What does sharding mean?

1002

What is object data modeling?

969

How to define a procedure inside another procedure?

1024

What are the limitations oracle database 10g xe?

1046

How to convert characters to times in oracle?

1023

How to call a stored function in oracle?

1018

What types of joins are used in writing subqueries?

985