A PRIMARY KEY DOES NOT ACCEDES DUPLICATIONS . A FOREIGN KEY IS USED FOR LI

what is the difference between primary key & foreign key?

Question Posted / bharathi sundar

57 Answers
135110 Views
CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
E-Mail Answers

Answer Posted / bharathi sundar

A PRIMARY KEY DOES NOT ACCEDES DUPLICATIONS .
A FOREIGN KEY IS USED FOR LINKING TWO DATABASE TABLES
ABSTRUSELY .

A FOREIGN KEY USES THE PRIMARY KEY IN ANOTHER TABLE,
TO RETRIEVE OR TO IDENTIFY THE CELL VALUES IN ANOTHER
TABLE.........

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to convert raw data type into text in oracle? Explain

953

What is archive log in Oracle?

1071

What privilege is needed for a user to create indexes in oracle?

965

Explain the use of analyse option in exp command.

1067

Explain the dml?

921

Is it possible to split the print reviewer into more than one region ?

2224

How to use "out" parameter properly?

1028

Can we commit inside a function in oracle?

920

What are the restrictions in a oracle read only transaction?

969

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2997

How to define and use table alias names in oracle?

885

How to use existing values in update statements using oracle?

1012

How to get execution statistics reports on query statements?

1009

Explain the use of grant option in imp command.

959

Explain the use of full option in exp command.

1057