ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
 Question Submitted By :: Ravis190784
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
Answer
# 1
Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the   key will act like a primary key for the
table.
 
Is This Answer Correct ?    1 Yes 1 No
Jayaraj
 
  Re: what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
Answer
# 2
Unique identitiy key is generated during data load process 
(ETL) in the datawarehouse system is called as Surrogate 
key.
It is mainly used to update slowing changing dimesion 
attribute data and also it removes dependencies on key 
originating in different data sources.

Primary key is uniquely identified each record in a table 
with no null values.
 
Is This Answer Correct ?    0 Yes 0 No
Rajesh S. Chandan
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
how do u do Performance tunning ? Satyam1
how many joins we can write if at all we have n no of tables Tanla-Solutions4
which database is best to use in oracle and sql server? explain reasons? TCS5
What is excution Plan in sql server TCS1
What is MSDE?  2
Can you explain the types of Joins that we can have with Sql Server?  2
what is physical sort data and logical sort data in index?  2
Explain Trigger with an example?  1
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
How to link up the text file to a Database table? Allianz1
Which system table contains information on constraints on all the tables created?  2
what is the main difference between constraints(like primary key etc..)& joins? Annik2
What is the difference between SSAS 2000 and SSAS 2005? APX1
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
What is the difference between distinct clause and group by clause? Value-Labs1
Accidentally i deleted my table. How can i get that table?  4
What are the new features in SQL Server 2005? Emphasis2
Explain sp_configure commands, set commands?  3
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)? Marlabs8
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com