foreign key is NULL foreign key reference as Primary key in another table

what is the difference between primary key & foreign key?

Question Posted / shree

Answer Posted / shree

foreign key is NULL
foreign key reference as Primary key in another table

Primary key is unique
primary key is not NULL and

Is This Answer Correct ?

46 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What happens if the imported table already exists?

1077

What is a nvl function?

1092

How to use group functions in the select clause using oracle?

1132

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

1075

How to create a testing table in oracle?

1031

Which environment variables are absolutely critical in order to run the OUI?

2171

ABOUT IDENTITY?

2109

What are the various constraints used in oracle?

1093

How to write a query with a right outer join in oracle?

1220

Explain alias?

1193

1) Does oracle have any table which contain all the exceptions and it's code internally?

1801

does the query needs a hint to access a materialized view?

1905

What is ASM (Automatic Storage Management) in Oracle?

1242

How do I start tns listener?

1095

How to create id with auto_increment on oracle?

1040