what is the difference between primary key & foreign key?

Answer Posted / o p yadav

primary key is the unique value,but its not nul values..
this kry is avoided dublicate values

foreign key is always references the primary key and allow null value.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an oracle database manually?

568


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1698


What is MTTR advisor in Oracle?

608


What is tns name?

543


What is the data type of dual table?

523






What is a named program unit?

580


How to store pictures on to the database?

526


What are the most common interview questions on ETL Testing for experience?

589


How to load a large xml file?

580


How many types of cluster table in Oracle?

573


Why is oracle so popular?

558


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4665


When do you get a .pll extension in oracle?

677


Explain the function of optimizer in oracle?

594


How to specify default values in insert statement using oracle?

556