what is the difference between primary key & foreign key?

Answer Posted / guest

Primary key is unique
primary key is not NULL and

foreign key is NULL
foreign key reference as Primary key in another table

Is This Answer Correct ?    250 Yes 62 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop a stored procedure in oracle?

578


What is open database communication (odbc) in oracle?

536


How to connect to oracle using service name instead of sid?

541


Can a formula column referred to columns in higher group ?

2079


How to use "if" statements on multiple conditions?

711






21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609


Is it possible to insert comments into sql statements return in the data model editor ?

2061


How to update values on multiple rows in oracle?

591


definition of cluster and non-clustered index?

2467


What is a named program unit?

569


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

1479


How to rename a tablespace in oracle?

607


How to test null values?

664


How to create a new table in oracle?

583


How are extents allocated to a segment?

567