• I have to agree that this was a great question and don't see how it could be interpreted any other way. I think the "trap" may have been people knowing how the bit data type behaves in SQL Server and reading only what they wanted to read in the question. I'll admit, I saw it was a bit data type then read "which of the following values will be inserted" and almost went directly to answering without finishing the question since I was familiar with bit conversions. Fortunately I stopped myself, read the ENTIRE question, then answered.