GeekInterview.com
Series: Subject: Topic:
Question: 15 of 58

what is difference between candidate key and primary key

Asked by: suresh.kalyadapu | Member Since May-2008 | Asked on: May 9th, 2008

View all questions by suresh.kalyadapu

Showing Answers 1 - 3 of 3 Answers
shankcool

Answered On : Jun 2nd, 2008

View all answers by shankcool

A candidate key is a unique identifier that could be used as a primary key, which when you choose the primary key, the rest will then just be data fields

Yes  1 User has rated as useful.
  
Login to rate this answer.
basabdutta9

Answered On : Oct 17th, 2008

View all answers by basabdutta9

Primary key is the unique key to identify a record and Candidate key is composed of one or more than one key to make it unique.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
veerbahadur

Answered On : Dec 24th, 2008

View all answers by veerbahadur

Any attribute that is uniquely identify a row in a table is candidate key for the table. We select one of the candidate key as Primary key. All candidate keys which are not chosen as "primary key" are Alternate keys. The key which uniquely identify the rows of the table and which is made up of more than one attribute is called Composite key. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys.

Yes  3 Users have rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.