Primary key is unique primary key is not NULL and foreign key is NULL

what is the difference between primary key & foreign key?

Question Posted / guest

Answer Posted / guest

Primary key is unique
primary key is not NULL and

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

Is This Answer Correct ?

250 Yes

62 No

Please Help Members By Posting Answers For Below Questions

How to connect to the server with user account: sys?

1019

Explain table?

1116

Can we use bind variables in oracle stored procedure?

950

What is a snapshot in oracle database?

1025

what happened to the global index when I truncate the data in one of the partition?

2022

Does facebook use oracle?

1031

Can we call procedure inside function in oracle?

1093

Is the After report trigger fired if the report execution fails ?

2915

List out the components of logical database structure of oracle database.

1036

Explain the difference between a procedure and a function? What do you understand by those terms?

1082

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

2043

What is difference between truncate and delete?

1040

What is the use of file param in imp command?

1165

How to call a stored function in oracle?

1018

What is sequence?

1083