what is the difference between primary key & foreign key?

Answer Posted / mithun

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.

Is This Answer Correct ?    21 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1849


what are steps for interface? where is exchange rate defined in which table?

1501


What happens if variable names collide with table/column names?

584


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1515


material view and view disadvantages?

637






How to convert numbers to characters in oracle?

590


How to get maxsal , minsal, ename department wise in single query

1022


What is system tablespace?

632


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1786


What happens if the update subquery returns multiple rows?

612


How to create a new tablespace in oracle?

560


What is save point in oracle database?

730


What is dual table oracle?

527


What is Data Dictionary Cache in Oracle?

664


What are the limitations oracle database 10g xe?

572