Differentiate between unique key and foreign key?



Differentiate between unique key and foreign key?..

Answer / Vivek Anand

A unique key ensures that each row in a table has a distinct value for the specified column(s), while a foreign key establishes a link between two tables by referencing the primary key of another table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key

1 Answers   Ignou,


What is the Lock Based Protocol used for?

1 Answers   Hexaware,


What is the role of tester in discovery(in Checklist)?

1 Answers  


How many types of normalization? What is the use of it?

1 Answers   Accenture,


please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

1 Answers  


First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1 Answers   IBM,


Is it good to store images in database?

1 Answers  


During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1 Answers  


Does facebook use graph database?

1 Answers  


Explain phantom deadlock?

1 Answers  


In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries?

1 Answers   CTS,


hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 Answers  


Categories