Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the difference between primary key and foreign key?

Answers were Sorted based on User's Feedback



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

Answer / gaytriom

A primary key is a column which uniquely identifies the
records in a table. In a broad sense, a primary key is the
mixture of a unique key and an index: A collumn with a primary
key is indexed to deliver a faster query, and doesn't allow
duplicate values to ensure specific data.

A foreign key is a column (the child collumn) in a table which
has a corresponding relationship and a dependency on another
collumn (the parent collumn) that is usually in a different
table. Parent collumns can have multiple child collumns, but a
child collumn can only have one parent collumn.

Is This Answer Correct ?    11 Yes 1 No

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

Answer / vimal chauhan

Primary key does't allow null value
while foreign key allow null value

Is This Answer Correct ?    11 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

How to Insert a TextBox value in to Sql database using C# coding?

17 Answers   HCL, Sona, TCS,


What are the various session state management options provided by asp.net?

0 Answers  


How long should a session id be?

0 Answers  


List some of the important session state modes of asp.net.

0 Answers  


What parameters can you pass in the url of the api? Can get and post use the same url?

0 Answers  


You need to retrieve data from a Microsoft SQL Server 2000. Currently you are using an oleDbConnection object to connect to the database server. You need to be able to retrieve the data from the database server in XML format. Which approach would be the most efficient? Select all that apply. Each answer constitutes part of the whole answer. a) Change to the SQL .NET provider. b) Use the ExecuteXmlReader() method of the xxxCommand object c) Use the DOM to create the XML document. d) Use the XmlDocument.Load() method to create the XML Document.

1 Answers   Syntax Softtech,


When should I use server transfer and response redirect?

0 Answers  


How you will handle session when deploying application in more than a server? Describe session handling in a webfarm, how does it work and what are the limits?

3 Answers   CoreObjects,


14. What are your Future Plans for Swatz Oils GROUP U.K?

0 Answers   CSC, Swatz Oils, TCS,


What is .net remoting?

0 Answers  


What is csrf attack in asp.net?

0 Answers  


Is overloading possible in web services?

3 Answers   Microsoft,


Categories