Er.Abhay Shukla

Chapter 1: Basic .NET Framework What is an IL? What is a CLR? What is CTS? What is a CLS (Common Language Specification)? What is a Managed Code? What is a Assembly? What are the different types of Assembly? What is NameSpace? What is Difference between NameSpace and Assembly? If you want to view an Assembly how do you go about it? What is Manifest? Where is version information stored of an assembly? Is versioning applicable to private assemblies? What is GAC? What is the concept of strong names? How to add and remove an assembly from GAC? What is Delay signing? What is garbage collection? Can we force garbage collector to run? What is reflection? What are different types of JIT? What are Value types and Reference types? What is concept of Boxing and Unboxing ? What is the difference between VB.NET and C#? What is the difference between System exceptions and Application exceptions? What is CODE Access security? What is a satellite assembly? How to prevent

Milestone 2 to Interview Questions ASP.NET/SQL C# Static Constructor Static Method HTTP Context HTTP Module SQL                    Magic Tables Instead of trigger Schema binding with views Use DML in functions using schema binding Optimization techniques ·        Handle deadlock, Can use no lock or related alternatives for this. ·        Useful clustered index and as per need minimum non clustered indexes detailed analysis specially on large tables ·        Integer/numbers for joins ·        Avoid nested queries use joins ·        Avoid cursor ·        Create maintenance plans for Index Rebuild    To be continued...