what is the difference between primary key & foreign key?

Answer Posted / altaf ali

primary key of a relation is a candidate key that has been
designated as the main key.It doesn't has null value.

A foreign key is an attribute in a relation that can be
used as a key to another relation.It allow null and
duplicate value.

Is This Answer Correct ?    16 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to install oracle database 10g xe?

566


How to set a transaction to be read only in oracle?

582


what are bitmap indexes? How does they work?

1719


Write a trigger example in oracle?

575


What is the simplest tool to run commands on oracle servers?

520






What is format trigger?

1616


What are the components of logical database structure in oracle database?

583


Explain oracle’s system global area (sga).

626


How to bring a tablespace offline?

543


In which language oracle has been developed?

649


What is the fastest query method to fetch data from the table?

866


How to run create database statement?

579


what is dynamic SGA and static SGA

3843


What is meant by joins?

623


How many categories of data types?

576