The "delete table BBB;" statement in d) will fail.

Good question, but wrong answer. Should be "Enable backup compression" and "Create a user that is classified into a limited CPU workload group in Resource Governor"

It is possible to run both these operations in SQL Server concurrently, but not on the same database.

The question is not really about datetime precision, but string comparison.

If the comparison value had been declared as datetime, then the other values would be implicitly converted to datetime as...

It will return the same if the table has data.

If the table is empty, sum(1) will return Null where count(*) would return 0, so not always exactly the same.

I'm using 2008 R2. The correct answer is listed as sys.dm_os_sys_performance_counters, but in the...

None of the listed views exist.