Interview Questions based on practical understanding

It is a general practice to ask practical oriented questions that help interviewer to understand the ability of candidates. These practical oriented questions can be answered easily on the base of experience.
Can we create a View on a table which is not exist in database ? (in MS SQL)
When will you use View and when Stored Procedure?
Can we disclose only 10 WCF functions out of 15 to a particular customer or user ? (in WCF)
Suppose we want to charge customer based on no of calls made to our WCF function, so is it possible to do so in WCF? [More]

What is SignalR ?

SignalR is new buzz in development technology. It is not going to replace asp.net but works for asp.net. It is a technology ( in more technical words it is a library) that facilitate us to add real-time functionality into our asp.net based applications. It is very useful where high time/real time update is required like online group gaming, chat, stock trade etc. [More]

CS vs IT

CS or CSE is just like a superset of IT, it has more specialization than IT and must be preferred choice. It opens broader scope in terms of higher education, government job compare to IT. MSc (CS) vs MSc(IT) BTech(CS) vs BTech(IT) [More]