The answer seems to be Yes and no. It is documented and I tried it. That's the correct answer and should receive the points

I think re-entrant is also a correct answer. Looking at books online you find the context described as reentrant as well. We should be awarded the points for...

Agree with all the comments below. This was not nchar, but nvarchar, which means variable. The answer given as correct would have been true for nchar. I...

AHHHHH... yes! Why did I miss that?!

Thanks!

If the column 1 in the table HAD a null value for one of the rows, how could the resulting table POSSIBLY end up being defined as NOT NULL?

I chose both tables... I believe that is ALSO a correct answer!

Think about it... where in this question did it say that col1 in the first table didn't have nulls?

I...

I definitely want my points for the 1,1 answer.

NOCOUNT is off by default. If NOCOUNT is set ON you may get 0 first, otherwise, by default you get 1...

It will actually generate an error.

Agree with previous comments regarding inability to reorganize with the page locks option off. You don't have any option but to rebuild or drop/recreate the index with Allow_page_locks on....

I disagree.

There's overhead to varchar. If you don't need it, you don't put the variable overhead! That's why it's available.

I think recognizing that MDX is NOT TSQL should give us our points.

MDX is not TSQL. My answer was correct since the topic was labeled T-SQL Operators.

MDX <> TSQL. Except is not a correct answer.

At first I chose the db_ssisitduser, but then realized it's actually db_ssisLtduser. A very confusing typo!

Sparse columns REDUCE the space needed not negates: Sparse columns reduce the space requirements for null values at the cost of more overhead to retrieve nonnull values.

http://msdn.microsoft.com/en-us/library/cc280604.aspx