Virtusa Interview questions (1 st Round)

1.       When use Web Api ,WCF and web service

2.       Why we use session in asp.net?

3.       Difference between MVVM and MVC pattern. Which one is best architecture patter?

4.       How to improve the performance in stored procedure.

a.       Except index?

5.       When we need use CTE, temporary table and table value.

6.       Why need use agile methodology in our project

7.       How do you perform peer review? Which things you consider in code review comments ?

8.       Why we need re-sharper  tool?

9.       What are design pattern used in your projects

10.    I have table contain multiple columns and I want to filter  the columns which contains value alpha numeric  text  and may be rest of data have junk value in columns.  How do pull out data using (query or your approach) without affecting performance.  (In production environment and it contains millions records).  – Sql server

11.   Have your ado.net model in your project ( connected or disconnected architecture)

12.   Have you used Ranking function in Sql server.

13.   Type of Session modes?

14.   Do weed drop the table variable parameter?

15.   How do perform the unit test MVC and Business and DAL layer

16.   How do perform integration testing?