Interview Questions ASP.NET Series 2


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...

Popular posts from this blog

Excel Key Board Shortcuts

Shortcut key Action Menu equivalent comments version Ctrl+A Select All None All Ctrl+B Bold Format, Cells, Font, Font Style, Bold All Ctrl+C Copy Edit, Copy All Ctrl+D Fill Down Edit, Fill, Down All Ctrl+F Find Edit, Find All Ctrl+G Goto Edit, Goto All Ctrl+H Replace Edit, Replace All Ctrl+I Italic Format, Cells, Font, Font Style, Italic All Ctrl+K Insert Hyperlink Insert, Hyperlink Excel 97/2000 + Ctrl+N New Workbook File, New All Ctrl+O Open File, Open All Ctrl+P Print File, Print All Ctrl+R Fill Right Edit, Fill Right All Ctrl+S Save File, Save All Ctrl+U Underline Format, Cells, Font, Underline, Single All Ctrl+V Paste Edit, Paste All Ctrl W Close File, Close Excel 97/2000 + Ctrl+X Cut Edit, Cut All Ctrl+Y Repeat Edit, Repeat All Ctrl+Z Undo Edit, Undo All F1 Help Help, Contents and Index All F2 Edit None All F3 Paste Name Insert, Name, Paste All F4 Repeat last action Edit, Repeat. Works while not in Edit mode. All F4 While typing a formula, switch b
Read more

Places to visit - Chandigarh

Inside City places to visit in Chandigarh -  ·         Rock Garden ·         Sukhna Lake ·         Elante Mall ·         Mansa Devi - Shakti Peeth (Panchkula) ·         Saketri Shiv Temple ·         Nada Sahib Gurdwara – Panchkula ·         Sector 17 Market, Especially in weekend evening. ·         Shashti Market sector 22 Chandigarh Outside Nearby places to visit near Chandigarh ·         Shimla, Himachal Pradesh - Hill Station,110 Km from Chandigarh (3.30 to 4 Hours) ·         Kasauli - Hill Station 40 Km from Chandigarh 1.30 to 2 hours. ·         Pinjore Garden, Pinjore - 10 Km from Panchkula/Chandigarh. ·         Chail – Near to Solan Local Taxi's  ·         You can easily travel locally using Uber/Ola in Chandigarh with very effective cost. ·         You can book whole day cab (Sedan Class) for Shimla for approx. 2500/- per day. ·         Local cabs can be booked for whole day 1600 to 1800/- per day.
Read more

Interview Questions Beginner - ASP.NET

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
Read more