what is the difference between primary key & foreign key?

Answer Posted / raja

foriegn key always refers to
primary key but Primary key is unique key

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4021


Explain the use of rows option in exp command.

585


How to end the current transaction in oracle?

562


What are the major difference between truncate and delete?

519


Is insert autocommit in oracle?

608






How to define a procedure inside another procedure?

549


How to delete multiple rows from a table in oracle?

565


What is recovery manager(rman) backup in Oracle?

629


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1615


What are group functions in oracle?

585


Explain what are the characteristics of data files?

631


Which is better Oracle or MS SQL? Why?

3980


What is an Oracle index?

1181


Give the various rollback segment states.

579


What is the usage of control file in oracle?

611