what is the difference between primary key and foreign key?

Question Posted / preethi

3 Answers
5737 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between primary key and foreign key?..

Answer / shiva

the primary key is used identified the unique value
presented in the table but foriegn key is used to refer the
value of the table that have unique vale,multiple foriegn
key present in multiple tables

Is This Answer Correct ?

6 Yes

0 No

what is the difference between primary key and foreign key?..

Answer / preethi

a table must have single unique primary key but mutiple
foriegn key to refer different tables.

Is This Answer Correct ?

7 Yes

3 No

what is the difference between primary key and foreign key?..

Answer / aaa

combination of columns is called primary key and columns in
one table whose primary key matches with other table is
foreign key

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More Engineering AllOther Interview Questions

Please can any tell what is the difference between method overloading and overriding in c#.net ?

2 Answers

when did actually oil exploration start

0 Answers

A rectangular beam section of 300 mm width and 500 mm effective depth is reinforced with 4 bars of 20 mm diameter, what shear reinforcement is required to resist 200 kN shear (use working stress method)?

0 Answers

how to delete four out of five duplicate records in a table using sql

0 Answers

what is difference between server 2008R1 and 2008 server R2?

0 Answers NSIT,

Describe an impedance matching circuit?

2 Answers

Write a program to input 10 elements in an array and seperate even and odd numbers, positive and negative between them ?

0 Answers

WHO IS STAR....?

1 Answers TCS,

explain inflation ,deprication ,time of value & pf tariff

0 Answers

2. A product selected for testing is equally likely to have been produced by one the 6 machines/processes. (i) Determine sample space ‘S’ (ii) What is the probability that the product is from machine 1? (iii) What is the probability that the product is from machine 2 or machine 4? (iv) What is the probability that the product is from both machine 5 and machine 3? (v) What is the probability that the product is not from machine 6? (vi) What is the probability that the product is not from either machine 6 or machine 1?

0 Answers

How do aeroplanes fly? Why can some fly up-side down?

0 Answers

Write a C/C++ program that connects to a MySQL server and checks if the InnoDB plug-in is installed on it. If so, your program should print the total number of disk writes by MySQL.

0 Answers

For more Engineering AllOther Interview Questions Click Here