what is the difference between primary key & foreign key?

Answer Posted / muneer

Primary Key is unique Key entire the table and which is
also NOT NULL
where as foriegn key is the null & which references the
primary key .

Is This Answer Correct ?    147 Yes 28 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a named program unit?

569


How to select an oracle system id (sid)?

574


How to join two tables in a single query using oracle?

557


IS it possible to built the oracle database without setting the kernal parameters?

1753


What does sharding mean?

529






Explain do view contain data?

574


What are the execution control statements?

603


Explain the use of inctype option in exp command.

585


Give the advantages and disadvantages of clusters.

566


How to rename a column in an existing table?

609


How many data types are supported?

608


Explain the use of control file?

645


What is a cursor variable?

561


what are bitmap indexes? How does they work?

1709


How to write an inner join with the where clause in oracle?

573