GeekInterview.com
Series: Subject: Topic:
Question: 43 of 43

What is an artificial (derived) primary key? When should it be used?

Asked by: Interview Candidate | Asked on: Jul 21st, 2005
Showing Answers 1 - 5 of 5 Answers
John

Answered On : Jun 24th, 2005

Using a name as the primary key violates the principle of stability. The social security number might be a valid choice, but a foreign employee might not have a social security number. This is a case where a derived, rather than a natural, primary key is appropriate. A derived key is an artificial key that you create. A natural key is one that is already part of the database.

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

Answered On : Jul 21st, 2005

whether artificial primary key is equvalent to the row_id of the table or it is the the combination of the previous primary key field and the new field which creates the importance of it.

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

Answered On : Oct 4th, 2005

Many at times Natural Keys are based on Categorizations that are perceived permanent.However due to natural or artificial changes these nomenclatures bacome meaningless for the new transactions.It is also true that with the new transactions Natural Keys might loose their importance.Such are the situations with Slowly and Fast changing dimensions.

To avoid this Surrogate Keys are used that are Auto Generated, are Integer Keys and they take less query execution time.

  
Login to rate this answer.
geeksds

Answered On : Sep 18th, 2008

View all answers by geeksds

It is a system-assigned number that is unique for each row of data in a table.  It is used by database administrators to allocate rows of evenly and efficiently on data storage / servers. 

  
Login to rate this answer.
mvg_mca

Answered On : Mar 12th, 2010

View all answers by mvg_mca

A derived key comes from a sequence. Usually it is used when a concatenated key becomes too cumbersome to use as a foreign key.

  
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.