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

Answer Posted / b.jaganathan

PRIMARY KEY: the key which is used in the database table
for an identification is said to be a "PRIMARY KEY"....


FOREIGN KEY: the key which is used in the another database
table is said to be a foreign key, for the specified data
table........

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we find out the duplicate values in an oracle table?

805


What is a sub query and what are the different types of subqueries?

847


How to count duplicated values in a column in oracle?

750


How to define a data field as not null?

831


various types of hints and their usage

2347






Is it possible to insert comments into sql statements return in the data model editor ?

2310


Explain the use of rows option in imp command.

765


What is different types of joins?

753


What's dateware house and what's clustor with practicle example

1886


What are the arithmetic operations?

790


Explain overloading. Can functions be overloaded?

756


When do you get a .pll extension in oracle?

893


can anyody please send me the dump for Oracle 10g certifications for DBA path?

1899


How to install oracle database 10g xe?

755


What is a server parameter file in oracle?

771