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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 
Questions on identity?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Questions on identity?
Answer
# 1		 
Identity (or AutoNumber) is a column that automatically 
generates numeric values. A start and increment value can 
be set, but most DBA leave these at 1. A GUID column also 
generates numbers; the value of this cannot be controlled. 
Identity/GUID columns do not need to be indexed. 

Syntax :

  IDENTITY ( seed, increment )
 
Is This Answer Correct ?    1 Yes 0 No
Magu
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
From where can you change the default port?  3
What are the different types of backup avaible in SQL SErver Emphasis5
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?  2
what is the Enterprise manager(2000) and management studio (2005)?  2
how to get the rowid/rownumbes of a table in sqlserver IBM5
UPDATE statement can on a single table or on the multiple table? iGate5
What are the magic tables in SQL Server 2000? Infogain5
Can anybody explain me cold backup and hot backup? TCS3
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz... Value-Labs5
What is a sub-query? When would you use one?  3
What are the types of model in sql server and explain TCS1
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  2
What is RAID and what are different types of RAID configurations? Wipro5
what is the order of execution of where,having,group by in select stement Tanla-Solutions5
Difference between Cluster and Non-cluster index? Oracle9
What are the steps you will take to improve performance of a poor performing query? HCL1
What is a Linked Server?  1
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.  1
What types of integrity are enforced by a foreign-key constraint  1
What is an index? Yardi-Software7
 
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