Thank for the post, Steve, interesting one.
(Well, the score is exact 50-50 at this moment; the most common data type for identity column is INT, I am sure or trying to stay positive, that 50% of people who answered it wrong selected the choice by practice, even though they knew it, its just a practice haphazard. I was going to be one of them as I use it commonly, but vaguely I knew that it can take others too as a valid type, so I selected the answer and I did not submit and went and created 6 tables 😀 to be sure. Creation part was success and my doubts crept in possibly it might throw error at the inserting time.... and then I inserted record in each table... YES!!! no issues at all. Finally my first selected choice as correct... and it was time to click "submit".) 😛
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.