SQLSERVER

Dotnet Interview Question: OOPS:  Abstract classes, Interface, Encapsulation, Method hiding, Method overloading, Generics,collection,Delegates,Extension Methods. SQL: Joins, Stored procedures, functions, triggers, transactions, ACID, Normalization. Highest salary query. eliminate duplicate records. Table variables. Temp tables. views. Indexes. ASP.net: state management. page life cycle events. Server.transfer vs Response.Redirect WCF: contracts. security. Design Patterns: singleton. Factory. Abstract Factory. MVC: Routing. Filters. Results. Data Annotations. ADO.net: DataReader. Datasets. Project: Challenges in the current project. Roles & Responsibilities. Number of classes used. Which module you worked in the project. How you have done email notification in MOD(Manager on Duty). How to close the active incidents query. What design you implemented in the project. How do you create incidents query. who is u