• This was so easy I answered right away without hesitation. Then, I noticed it was a two point question and that gave me doubt. Those two point questions always have some twist to them. So, I looked up the definition of deterministic to make sure I understood the word correctly.

    Definition: In computer science, a deterministic algorithm is an algorithm which, in informal terms, behaves predictably.

    Also, for those interested, Steve had a nice post about this function on June 28, 2011:

    http://www.sqlservercentral.com/blogs/steve_jones/2011/06/28/hashbytes-_1320_-a-t_2D00_sql-function/

    I got it right but I was scared to push that submit button.