what is difference between foreign key and reference key

Answer Posted / soujanya

Foreign key is the key i.e. attribute which refers to
another table primary key. Reference key is the primary key
of table referred by another table.

Is This Answer Correct ?    37 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between sharding and replication?

493


how to clone 9i Database on to 10g Database.

1835


What is the difference between $oracle_base and $oracle_home?

596


various types of hints and their usage

2139


How to assign a table row to a record variable?

590






Explain integrity constraints?

686


What is a dynamic performance view in oracle?

615


Can you assign multiple query result rows to a variable?

562


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2741


What is meant by a deadlock situation?

587


How to call a sub procedure?

576


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1888


What are the common oracle dba tasks?

633


What is an Oracle index?

1186


What is the maximum limit on the number of columns in a table?

561