what is the difference between primary key & foreign key?

Answer Posted / zacharia ismail

primary key: primary creates a clustered index on the
column and it doesn't allow null values.
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert numbers to characters in oracle?

584


Differentiate between translate and replace?

625


How to update values on multiple rows in oracle?

596


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

1736


ABOUT IDENTITY?

1554






What privilege is needed for a user to delete rows from tables in another schema?

562


why dont we assign not null constraint as table level constraint.

2252


What is Java Pool in Oracle?

602


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1784


State some uses of redo log files?

554


Does oracle charge for java?

587


What is data type in oracle?

558


Can you assign multiple query result rows to a variable?

546


What is the data pump import utility?

578


Give the different types of rollback segments.

578