[font="Courier New"]Going thru the comments, it seems NOT everyone is aware that NOT NULL clause is necessary when altering the column. It’s a simple fact but not everyone knows about that. I am still surprised over ¾ of the people got this incorrectly. I hope at-least few people will know more about NULL bitmap because of this QoD.

Hugo mentioned that I might get some grief over the answer options. I tried to come up with a different set of answer options that are intelligent yet simple and relevant but didn’t make it this time.

I tried to bring a fresh look for the QoD, like a code review instead of just asking a random question. Look at this question as a code review project and not just a random out of the box question.

I have few ideas for the next QoD’s and will try to make them better from the feedback I received here. Thanks for participating in this and sharing the feedback (both good & bad). Appreciate it.

[/font]