what is the difference between primary key & foreign key?

Answer Posted / shree

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 ?    46 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1522


What are the extensions used by oracle reports?

571


What is the difference between translate and replace?

554


What is materialized view in Oracle?

630


How to list all indexes in your schema?

578






What are the ansi data types supported in oracle?

518


How to drop a stored procedure in oracle?

590


how the indexes are stored in the Oracle Database?

1736


What is parameterized cursor in oracle?

574


What happens to indexes if you drop a table?

698


How to define a cusotmer as a supplier in ORACLE R12

1726


What is the difference between pre-select and pre-query?

621


What is a private synonym?

1079


How to add a new column to an existing table in oracle?

586


How to change program global area (pga) in oracle?

582