Yes, too easy. I wasn't sure about the DCL but I knew the DDL and DML and only one choice had the last two in the right order.

Nowhere did the question state that this is a production server. Further, the practice of not backing up development or test servers is also questionable. I came across this situation...

No, the part I didn't get was that the result of integer division must be an integer no matter what the result data type is. I didn't know that.

Chalk it...

Good question. I missed it.

Well, the test I ran was on SQL server 2000 Standard on Windows 2000 Server.

Even though I got the question wrong, like the majority seems to have, when I test this out it does work as the answer states.

As a matter of fact, if...

From BOL:

NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making a backup copy of it and truncates the log. This option frees space. Specifying a backup device...

Yes, but as was mentioned earlier, that returns the byte-length of the data which would be 2x the length for a unicode field:

DECLARE @myString nvarchar(100)

SET @myString = '  TEST ...

Microsoft: When we say "Standard", we mean the way we think everyone else should do it.

From a practical standpoint, I think this was done because of the behaviour of CHAR...

Ok, back to QOD:

6 is right answer, but reason is wrong. LEN excludes trailing spaces but counts leading ones:

From BOL:

LEN

Returns the number of characters, rather than the number of...

Uh, no. The MODEL database is the database from which any new database is created. It is best not to make changes to it unless you want those changes to...

BIG nod of agreement on this one.

There simply isn't enough information to make a good decision.

How often are log backups made? Database...

..filing under "you learn something new every day"

Thanks, Chris.

Good to know I'm retaining most of what I've done and read.

Good question if you make some assumptions:

1. The account running the SQL Server Service is a domain account or an account that matches a username and password on the server...