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   To Refer this Site to Your Friends   Click 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 UNIQUE IDENTIFIER DATA TYPE?
 Question Submitted By :: Ranjit Kumar Routhu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: WHAT IS UNIQUE IDENTIFIER DATA TYPE?
Answer
# 1		 
unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column 
with 16 charcters
ex: create table a( id uniqueidentifier default newid
(),....),newid() generates new 16 unique charcter values
 
Is This Answer Correct ?    0 Yes 1 No
Ranjit Kumar Routhu
 
  Re: WHAT IS UNIQUE IDENTIFIER DATA TYPE?
Answer
# 2		 
unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column 
with 32 charcters and not 16 characters
 
Is This Answer Correct ?    0 Yes 0 No
Tauseef
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How do I compare two values when one value(data type) is char and the other is an integer?  3
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database. Microsoft2
i need some interview questions on sql server developer plz any onee send some links.  1
Which system table contains information on constraints on all the tables created?  2
Accidentally i deleted my table. How can i get that table?  4
explain different types of jions with examples briefly? Zensar3
what command is used to create a table by copying the structure of another table?  5
How can i change the column name. HCL7
Where do you think the users names and passwords will be stored in sql server?  3
How can I know what query is executing by by a particural user? (using sp id or any othe way.)  2
What is RAID and what are different types of RAID configurations? Wipro5
can you any body tell me suppose database is suspect mode. how can take to normal? Teledata1
Can you tell me the difference between DELETE & TRUNCATE commands?  11
event classes in sql server Accenture1
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
Rate yourself in .NET and SQL ? Cognizent1
How to Get the last identity value used  4
What is user stored procedure & it purpose? Wipro3
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?  2
What is a deadlock and what is a live lock? How will you go about resolving deadlocks? Microsoft1
 
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