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

Explain the blob datatype?

630


What is object data modeling?

521


what are archived logs?

1726


 What are the oracle DML commands possible through an update strategy?

594


How to sort output in descending order in oracle?

590






How many file formats are supported to export data?

668


What is the data type of dual table?

539


How to count duplicated values in a column in oracle?

562


What is ASM (Automatic Storage Management) in Oracle?

721


How do I use unicode codesets with the weblogic jdriver for oracle driver?

568


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1489


Explain the use of rows option in exp command.

590


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1823


What is save point in oracle database?

742


how may join possible between (requisition with purchase order)

1712