what is the difference between primary key & foreign key?

Answer Posted / reddy

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 ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do a full database export?

637


State the difference between a primary key and foreign key?

518


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

860


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

562


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1276






what are the advantages of running a database in archive log mode?

1735


Why should I use oracle database?

575


How to define an oracle sub procedure?

601


How to name query output columns in oracle?

692


How to connect to a remote server?

563


How to set up autotrace for a user account?

599


What is a relational database management system?

678


Explain the types of exception?

654


How to start your 10g xe server from command line?

548


What is ceil and floor in oracle?

579