Series: Subject: Topic:
Question: 183 of 198

Difference between Primary Key and Aggregate Key?

Asked by: Beena | Member Since Sep-2005 | Asked on: Sep 19th, 2005

View all questions by Beena   View all answers by Beena

Showing Answers 1 - 3 of 3 Answers

Answered On : Oct 7th, 2005

its is not aggregate it is the alternate key primary key : the column which is used for thr unique identification of a record from a table is called the primary key alternate key : a column which is used for unique identification but not a primary key is called the alternate key

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

Answered On : Aug 3rd, 2006

aggregate fact tables have two types of keys-composite key-serrogate key (system generated key)So aggregate-key is a primary key

Login to rate this answer.

primary key:is a key on ( 1  or group of columns) used to identify a record uniquely.builds clustered index automaticallyAlternate key:is a key which is a unique key but not a primary clustered index builds automaticallysurrogate key:Its a another name for primary or altername key, if created on surrogate column(a column inserted artificially i.e. identity column).

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



twitter fb Linkedin GPlus RSS


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.