anthony.green (9/18/2012)
Maybe they are trying to see if you know the limits and basics of SQL, they are all valid questions.
I don't know that I agree. The first three questions are just trivia that I use Books Online to understand. How many string functions are there? I don't know. Want to know how the optimizer works?
As to question four... it can be anything. The default is 1433, but you can make it what you want within the limits of ports. So that question is actually off (unless they're looking for this answer).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning