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...

It does, but there are two problems with that:

1. It's not among the given alternatives

...

Easy enough. But I would personally assign whoever created that table with DATETIME instead of DATE to toilet cleaing duty for a week...

Well, there's usually not much real body to New Year's resolutions...

Brilliant! So now those of us who answered master_files are flagged as giving a completely incorrect answer, rather than an equally correct alternate answer.