primay key uniquely identifies records in relation. in a table only one pr

what is the difference between primary key & foreign key?

Question Posted / dimna

Answer Posted / dimna

primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.

Is This Answer Correct ?

17 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to generate query output in html format?

1111

How to create a new table by selecting rows from another table?

1076

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2955

What do you know about normalization? Explain in detail?

945

What are the differences between char and varchar2 in oracle?

1163

How to define a data field as not null?

1104

Who developed oracle & when?

997

Can multiple columns be used in group by in oracle?

979

What is a trace file and how is it created in oracle?

1048

How many types of synonyms in Oracle?

1115

What are the data types in oracle?

1035

Are truncate and delete commands same? If so why?

1144

How many types of database triggers exist?

1126

Give the various rollback segment states.

1047

Explain the use of grant option in imp command.

1020