You can remove the TOP  or the WITH CHECK option. Either will do the trick, as well as removing both.

Disappointed!

The way this question is asked it would be 11 hours, but I do get the confusion: that's what happens when British people try to Americanize the question, LOL....

We wait until the...

17-7 = 10, and then some minutes. Given that billing is per started hour, I'd venture that the available answers fall short.

I'm not even going to begin trying to figure out what the question is. My guess is at least half the text is missing.

There are two results that can...

The correct answer to this will depend on the setting of ANSI_NULL_DFLT_ON, since the NULLability of the CHAR column isn't specified.

The question is asked clearly: "What is the limit for rows in a Table Valued Constructor?". The documentation states that there is a limit. So there is nothing left...

A table valued constructor is only limited to 1000 rows when used directly as a source for an insert statement. When used to create a derived table there is no...

Part of the QotD is knowing defaults. This was left off, as many people do this and the default is to allow NULLs.

As a good practice, however, I agree....

Just to nit-pick: This will depend on the settings of ANSI_NULL_DEFAULT_OFF / ANSI_NULL_DEFAULT_ON for the session, or by the ANSI_NULL_DEFAULT database option. By default, these will be set such that...

Of course! That's obviously clear from the question😋

I would argue that in principle the explanation is correct. However, in the example given, this would result in zero rows, unless a very specific set of conditions are met....

Maybe it's a good idea to refrain from answering this until the correct answer has been reviewed...