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

Difference between inner join vs where ?

979

Describe the types of sub query?

942

How index is implemented in oracle database?

947

What is the sid in oracle?

904

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1854

Explain enable novalidate constraint.

1037

Explain the use of inctype option in exp command.

978

How to write a query with an inner join in oracle?

976

How do I manually create a database in oracle?

957

what is the difference between substr and instr function in oracle?

1036

What is an anonymous block?

1158

How to define an oracle sub procedure?

1060

How to retrieve data from an explicit cursor?

1009

What is dual table oracle?

928

How can you use check constraints for self referential integrity?

920