what is the difference between primary key & foreign key?

Answer Posted / reddy

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 ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1462


What is a tns file?

500


What is an oracle tablespace?

600


How to delete a column in an existing table in oracle?

601


How to create a new table by selecting rows from another table?

549






What is a trigger and what are its types in oracle?

532


What is Undo Management Advisor in Oracle?

609


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

1844


What is data type in oracle?

558


What are the uses of linked server and explain it in detail?

584


How to create a table index in oracle?

655


How to define default values for formal parameters?

592


How to rename a tablespace in oracle?

615


What privilege is needed for a user to create tables in oracle?

548


Does oracle database need java?

520