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 bit data type? and what are the information that can 
be stored inside a bit column?
 Question Submitted By :: Ynpradeep
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is bit data type? and what are the information that can be stored inside a bit column?
Answer
# 1
Bit is used to store boolean values . It stores 0 , 1 and 
NULL .
 
Is This Answer Correct ?    1 Yes 1 No
Sreejith S T
 
  Re: what is bit data type? and what are the information that can be stored inside a bit column?
Answer
# 2
Bit datatype is used to store boolean information like 1 or
0 (true or
false). Untill SQL Server 6.5 bit datatype could hold either
a 1 or 0
and there was no support for NULL. But from SQL Server 7.0
onwards,
bit datatype can represent a third state, which is NULL.
 
Is This Answer Correct ?    2 Yes 0 No
Meena Kurade
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
write query for fourth maximum salary from employee table Mind-Tree5
Alternative way to DetDate() function?  4
How to create logins using windows Authentication mode?  2
What is database normalization? Digicel5
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3 Google10
Difference between Function and Procedure-in general?  3
How to write query to Delete the records in child table and corresponding records in parent table Semantic-Space8
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables? HP1
What is lock escalation?  1
What are the pros and cons of creating extended stored procedures?  1
What are the steps you will take to improve performance of a poor performing query? HCL1
write down the code for "how we delete a table without using of Drop command " ? Sonata2
wht's the differece between sqlserver05 and sqlserver2000  3
How to list all tables having unique constraints in any of the columns in a database.  1
When do we use the UPDATE_STATISTICS command?  3
what is the difference between Delete and Truncate Geo-Research-Centre3
CLR Integration ? what is Notification services ? Satyam1
Differnce between sel server 2000 and 2005  3
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500  2
What is the difference between a Application Server and a Database Oracle2
 
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