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

Answer Posted / cm

example :

primary key table: emp ( ENO, ename, address)
here eno is primary key

foreign key: table hari( ENO, phone, salary)
here same eno from hari table is used to get the values
from emp.

Is This Answer Correct ?    32 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of table in Oracle?

619


Explain a data segment?

648


What happens if variable names collide with table/column names?

584


What is an oracle user role?

569


What is java oracle used for?

524






what is the scripts in data base?

1602


How to do a full database export?

637


How to rebuild an index in oracle?

552


What is a package in oracle?

562


Explain oracle’s system global area (sga).

626


How to define an anonymous procedure with variables?

545


What to do if the binary spfile is wrong for the default instance?

563


What are the system predefined user roles?

585


What is max rowid in oracle?

557


How to define an external table with a text file?

579