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

What happens to the indexes if a table is recovered?

568


What are the differences between number and binary_float in oracle?

559


What are the different types of synonyms?

581


What is the difference between post-database commit and post-form commit?

508


How to declare a local variable?

587






Explain parameter file in oracle.

572


How to update values in a table in oracle?

565


What do you mean by merge in oracle?

588


How to call a stored function with parameters?

555


How a database is related to tablespaces?

571


What would you do with an in-doubt distributed transaction?

1463


Can we write dml statement in function in oracle?

625


Explain oracle’s server parameter file.

559


How to create an oracle database manually?

559


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1464