What is bit datatype and what's the information that can be
stored inside a bit column?
Answers were Sorted based on User's Feedback
Answer / sd
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 ? | 9 Yes | 3 No |
What is database design and development?
Given an employee table, how would you find out the second highest salary?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about the database management systems.
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Write the fastest query to find out how many rows exist in a table?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to customize error conditions.
How long can an error message be in raiseerror function?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
Explain about a primary key?
Explain about relational operator join?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)