ASP.NET AND SQL SERVER Interview Questions

SQL SERVER:

1) DDL/DML triggers
2) Joins
3) Sql Profiler
4) DTS Packages
5) Sql server agent.
6) how to find the second maximum record.
7) how to find the 11 maximum record.
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY [TimeStamp]) AS RowId,*
FROM [LOG]) AS Collections
WHERE
Collections.RowId > 45
AND
Collections.RowId < 51
8) sql server 2005 vs sql server 2000
9) How to fetch the records of second highest marks in each section of the class.
10) Normalization forms?
11) Primary key, foreign key, candidate key, composite key, unique key explanation?


ASP.NET:

1) Session management
2) Client side session management
3) Validation controls
4) Web.config authentication, authorization
5) Generics
6) Page life Cycle
7) SDLC
8) web controls vs custom controls
9) Application vs Caching
10) Interface vs Abstract
11) Sealed Classes vs Serializable classes
12) Partial classes
13) Master page
14) MultiThreading and Single Thread
15) Events vs Delegates
16) Types of Serialization
17) static vs normal constructor
18) How to create object for the class and it is holding one private constructor only
19) Forms vs windows authentication
20) custom error page
21) mobile application vs normal web application difference
22) Singleton
23) Abstract class objects
23) Interface objects
24) try catch finally
25) Method overloading and overriding