What is the data type of the surrogate key?

  • Interview Candidate
  • 8
  • 10933

Showing Answers 1 - 8 of 8 Answers

Suma

  • Sep 20th, 2007
 

Always number

  Was this answer useful?  Yes

sindu

  • Nov 2nd, 2007
 

Numuric, because it generates Numuric values.

  Was this answer useful?  Yes

VAMSIKRISHNACH

  • Dec 6th, 2007
 

1.It is always integer.
2.This is because we are generating a key and best performance comes only when keys are numeric. so they generate keys numerically only so that sorting is also quiet cheap for numbers  compared to char,varchar.. 

  Was this answer useful?  Yes

tirukosri

  • Jun 4th, 2008
 

Surrogate keys are the system generated keys and used to eliminate the redundancy in the primary keys. So they are always integer numbers.

  Was this answer useful?  Yes

Aswin

  • Feb 4th, 2014
 

Why cant we use a GUID? which is more powerful and have good uniqueness

  Was this answer useful?  Yes

Liam Whales

  • Mar 24th, 2014
 

Anything that can always be uniquely generated and bears no relation on the underlying data

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions