1.How many columns a SQL table can hold.
2.How many string functions are there in SQL.
3.How many non-clustered indexes a SQL table can have.
4.What is the port to be used to connect SQL DB server.
Some of these questions seem valid to me as well
From your questions I feel that either
1. The interview panel was not experienced one and they have used "Google" to find "SQL Server Interview Questions" themselves OR
2. This is just an initial round
Anyways, your answers seem a bit rude to me in an interview
You could have politely said, "I don't remember the exact syntax as there is always Google and MSDN to help me out"
I have said this in some interviews and they were OK with it and say that they are only interested in the logic I use to solve the problem.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/