• I agree with many of the comments so far: this was not a good QOTD.

    The correct answer is that the a default create with no parameters supplied other than the name will create a db with primary data file size same as in the model db and log file size 1MB -or maybe not 1MB but something else? I think Hugo gave some strange rules for initial log file sizes which are not the same as those given in the BOL entries for Create Database in T-SQL Reference for SQL2008, for SQL2005, or for SQL2000, and he referenced MSDN documentation for them.

    The options for the answer all all just numbers of MB, so the question needs to specify the version of SQL Server (and maybe whether it is an evaluation copy or some beta or the ready to go version), and even then the person trying to answer would have to assume that it was an implied rule that the model database size was as shipped by MS - and even with that assumption the edition of SQL Server as well as the version would have to be stipulated, because the size of the model database files varies from edition to edition: that the sizes of the model database files are not the same in all editions is documented in BOL: for SQLS 2005 in http://msdn.microsoft.com/en-us/library/ms186388(SQL.90).aspx, for SQL 2008 in http://msdn.microsoft.com/en-us/library/ms186388.aspx, and for SQL 2000 in http://msdn.microsoft.com/en-us/library/aa174522(SQL.80).aspx.

    Tom