What is bit datatype and what’s the information

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is bit datatype and what’s the information that can be stored inside a bit column?

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.

(Continued on next question...)

Other Job Interview Questions

• How do you test proper TCP/IP configuration Windows machine?
• How many bits IP Address consist of?
• What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
• How many bits IP Address consist of?
• What are statistics, under what circumstances they go out of date, how do you update them?
• Define candidate key, alternate key, composite key.
• What kind of LAN types do you know?
• What's the maximum size of a row?
• If you encounter this kind of an error message, what you need to look into to solve this problem?
• How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
• More...