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

What is the quickest way to fetch the data from a table?

557


How to get the Installed Oracle Version Information ?

612


How to connect to a local oracle 10g xe server?

524


What does sharding mean?

530


Explain the features of oracle?

588






Explain temporal data types in oracle

597


Can group functions be used in the order by clause in oracle?

571


How to compare dates in oracle sql?

646


Explain the use of tables option in exp command.

585


How can I introduce multiple conditions in like operator?

545


What is the purpose of tables, private synonyms and public synonyms in Oracle?

581


What is a trigger and what are its types in oracle?

528


How to get maxsal , minsal, ename department wise in single query

1003


What is Segment Advisor in Oracle?

661


What is the difference between I and G in Oracle?

594