I agree.  I got the question right, but it works with the default settings only.  I thought the question would be about the ANSI NULL settings, obviously that affects the NULLability of the created columns.