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

Can we convert a date to char in oracle and if so, what would be the syntax?

550


What is bulk collect in oracle?

557


How do I find my oracle client driver version?

528


What is connection pool in oracle?

560


What is the meaning of recursive hints in oracle?

532






How to start instance with a minimal initialization parameter file?

542


what are actual and formal parameters?

596


What types of joins are used in writing subqueries?

569


Explain an integrity constrains?

702


Explain an index?

658


Why is oracle used?

557


What is Data Dictionary Cache in Oracle?

664


Can we use bind variables in oracle stored procedure?

492


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1860


How to define a variable to match a table column data type?

580