what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.

Answer Posted / ravi singh

Primary Keys: Primary keys are the identifier and applied
on the table in the form of constraints. Primary key
provides uniqueness in the data.

Foreign Key: Foreign Keys are the relationship and applied
on the table in the form of constraints. Foreign key in a
table is a primary key of another table and use to make
relationship between two tables.

Is This Answer Correct ?    59 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much memory your 10g xe server is using?

583


How do I uninstall oracle client from windows?

538


What are the ways tablespaces can be managed and how do they differ?

1618


Where is the export dump file located?

575


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

556






How can you merge two tables in oracle?

569


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1506


Is postgres faster than oracle?

561


Is rowid unique in oracle?

532


Are truncate and delete commands same? If so why?

656


What is a user account in oracle?

631


What is define in oracle?

571


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

526


What is oracle update statement with inner join ?

585


How to rename a tablespace in oracle?

621