what is primary key and foreign key when and where have to use

Answer Posted / raveendran

Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.

foreign key points to primary key of another table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is archive log in Oracle?

595


What is a read only transaction in oracle?

591


Can we store pictures in the database and if so, how it can be done?

585


What is oracle database 10g express edition?

593


What are a cluster and non-cluster index?

572






Respected sir, Please send me technical questions related to oracle apps..

1375


How to drop an index?

539


what are steps for interface? where is exchange rate defined in which table?

1493


What is clustered table in Oracle?

641


What is an oracle recycle bin?

548


How to export your connection information to a file?

592


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1579


How to apply filtering criteria at group level in oracle?

581


How do you find current date and time in oracle?

587


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1521