Chris, it appears that SQL Server requires the WITH SCHEMABINDING function option in order for a function to be identified as deterministic.

Here is a completely meaningless sample to show how...

I got the answer "correct" by choosing what I thought was the best choice out of the available options, but really, as Yelena pointed out, the answer is "it depends"....

I agree with other responses that the question is poorly worded. As others have already pointed out the the USING clause does not control what data gets inserted. It specifies...

The point made in a post above about using a scalar-valued function in the WHERE clause resulting in a full table scan is incorrect. When the function has no parameters...

I answered D and I was about to write that I agree with the above comments. However, after reviewing the question I believe the correct answer for the current wording...

I completely agree with the previous comments. The options were poorly worded.

The explanation incorrectly states that & performs a logical and operation between the operands but then proceeds to demonstrate how it performs a bitwise and operation. The...

I would have answered "(E). All of the above" except for the fact that "(D). ALTER TABLE and ALTER PROCEDURE only" was one of the above. So I ruled out...

I answered "correctly" based on the available answers. But ACID is not about concurrency support it's about transactional support. A system could support ACID transactions without supporting concurrency (sort of...

Jeff Moden's post using syscolumns gave me inspiration for a simple solution using new features of SQL Server 2005. It is similarly limited to the number of rows in sys.all_columns...

Here is a solution using CLR integration. It comes in around 5 seconds on my machine for the range range 5 to 567720.

public partial class UserDefinedFunctions

   ...

Wouldn't the correct answer be 'This is an interesting table ' (with an extra space on the end)?