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

What is bind variable in oracle 11g?

590


When do we use group by clause in a sql query?

571


Is postgres faster than oracle?

561


what are bitmap indexes? How does they work?

1719


How do I find the database name in oracle?

601






How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1473


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1744


How do you tell what your machine name is and what is its IP address?

1516


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1211


How to use subqueries with the in operator using oracle?

614


How to speed up webrick?

595


How do I limit the number of rows returned by an oracle query after ordering?

640


Explain about functional dependency and its relation with table design?

554


What are the differences between char and nchar in oracle?

603


What is the scope of a local variable?

585