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

Answer Posted / csprusty

To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is oracle a language?

522


What are the varoius components of physical database structure of oracle database?

567


How to export your own schema?

569


Why is oracle used?

552


State all possible different index configurations a table can possibly have?

562






What are the different windows events activated at runtime ?

2408


What is SQL access advisor in Oracle?

628


What is sharded cluster?

518


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1854


How can we force the database to use the user specified rollback segment?

556


what is difference between sql plus and sql*plus? (not sql and sql plus).

3342


What is Trigger in Oracle?

571


Where are the settings stored for each instance in oracle?

621


How to specify default values in insert statement using oracle?

556


What is catalog in Oracle?

647