ADP Qns

1) What is your current project architecture?

2) What is the need of different layers in architecture? Why don't we maintain all layers together?

Why use n-Tier architecture? 

• Because each layer can be located on physically different servers with only minor code changes, hence they scale out and handle more server load. 
• Also, what each layer does internally is completely hidden to other layers and this makes it possible to change or update one layer without recompiling or modifying other layers. 
• This is a very powerful feature of n-Tier architecture, as additional features or change to a layer can be done without redeploying the whole application. For example, by separating data access code from the business logic code, when the database servers change you only needs to change the data access code. Because business logic code stays the same, the business logic code does not need to be modified or recompiled. 

http://www.developerfusion.com/article/3058/boosting-your-net-application-performance/2/


3) What is internal?

4) What is sealed?

5) There is usercontrol which has two dropdowns, one contains Dept Ids and the other one contains respective employees. There are two instances of this usercontrol and if I select Dept from one dropdown, the other dropdown in another instance of usercontrol must be filled. How do you achieve this?

6) What are page life cycle events?

7) What are page life cycle events when there is usercontrol on the form? Tell me the sequence of events?

8) What are the performance improvement factors do you consider while writing stored procedure?

9) When do you use interface and abstract class?

10) How many ways are there to display data on gridview?