what is the difference between primary key & foreign key?

Answer Posted / baburao

primary key is a key which can define unique values
where as foreign key refers to a parent table and depends
on primary key

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you use check constraints for self referential integrity?

520


Explain constraining triggers.

593


What is oracle sid?

505


How to create a server parameter file?

571


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

608






Explain what are clusters?

612


State the various uses of dbcc command?

544


Give the various exception types.

542


What are the major difference between truncate and delete?

515


How to define an oracle cursor variable?

563


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

544


State and explain the different types of data models?

533


What is sharded cluster?

518


Where is the export dump file located?

568


How to insert multiple rows with one insert statement in oracle?

570