Dot Net Interview Questions
Dot Net Interview Questions
Dot Net Interview Questions
18. Explain the three services model commonly known as a three-tier application. Presentation (UI), Business (logic and underlying code) and Data (from storage or other sources). 19. Explain serialization? Serialization is a process of converting an object into a stream of bytes. .NET has 2 serializers namely XMLSerializer and SOAP/BINARY Serializer. Serialization is mainly used in the concept of .NET Remoting. 20. Whats MSIL, and why should my developers need an appreciation of it if at all? MSIL is the Microsoft Intermediate Language. All .NET compatible languages will get converted to MSIL. MSIL also allows the .NET Framework to JIT compile the assembly on the installed computer.
Class Questions
1. What is the syntax to inherit from a class in C#? Place a colon and then the name of the base class. Example: class MyNewClass : MyBaseClass 2. Can you explain what inheritance is and an example of when you might use it? When you want to inherit (use the functionality of) another class. Example: With a base class named Employee, a Manager class could be derived from the Employee base class. 3. Can you prevent your class from being inherited by another class? Yes. The keyword sealed will prevent the class from being inherited. The developer trying to derive from your class will get a message: cannot inherit from Sealed Class ClassName. 4. Can you allow a class to be inherited, but prevent the method from being over-ridden? Yes. Just leave the class public and make the method sealed. 5. Whats an abstract class? A class that cannot be instantiated. An abstract class is a class that must be inherited and have the methods overridden. An abstract class is essentially a blueprint for a class without an implementation. 6. When do you absolutely have to declare a class abstract? - When the class itself is inherited from an abstract class, but not all base abstract methods have been overridden. - When at least one of the methods in the class is abstract. 7. What is an interface class? - Interfaces, like classes, define a set of properties, methods, and events. But unlike classes, interfaces do not provide implementation. They are implemented by classes, and defined as separate entities from classes. - Its an abstract class with public abstract methods all of which must be implemented in the inherited classes. 8. Why cant you specify the accessibility modifier for methods inside the interface? They all must be public, and are therefore public by default. 9. Can you inherit multiple interfaces? Yes. .NET does support multiple interfaces. 10. What happens if you inherit multiple interfaces and they have conflicting method names? Its up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares youre ok. To Do: Investigate 11. Whats the difference between an interface and abstract class? In an interface class, all methods are abstract there is no implementation. In an abstract class some methods can be concrete. In an interface class, no accessibility modifiers are allowed. An abstract class may have accessibility modifiers.
12. What is the difference between a Struct and a Class? Structs are value-type variables and are thus saved on the stack, additional overhead but faster retrieval. Another difference is that structs cannot inherit.
2. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET? SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so its not as fast and efficient as SQLServer.NET. 3. What is the wildcard character in SQL? Lets say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve La%. 4. Explain ACID rule of thumb for transactions. A transaction must be: - Atomic it is one unit of work and does not dependent on previous and following transactions. - Consistent data is either committed or roll back, no in-between case where something has been updated and something hasnt. - Isolated no transaction sees the intermediate results of the current transaction. - Durable the values persist if the data had been committed even if the system crashes right after. 5. What connections does Microsoft SQL support? They support Windows Authentication (via Active Directory) and SQL authentication (via Microsoft SQL Server username and password). 6. Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted? Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction. 7. What does the Initial Catalog parameter define in the connection string? It defines the database name to connect to. 8. What does the Dispose method do with the connection object? It deletes if from the memory. It releases resources including unmanaged resources and performs the same action as Close(). 9. What is a pre-requisite for connection pooling? Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.
Assembly Questions
1. Define assembly? An assembly is the primary unit of a .NET application. It includes an assembly manifest that describes the assembly. 2. What is Assembly manifest? The manifest of an assembly contains assemblys data like version, scope, security information (strong name), ect. It also contains a reference to the resource and classes. It is stored in either an .exe or a .dll with MSIL code. 3. What is GAC (global assembly cache)? GAC is an area of memory reserved to store the assemblies of all .NET applications that are running on a certain machine. It shares assemblies among multiple .NET applications. The assemblies must have a strong name and must be publicly shared to be installed in the GAC. 4. How is the DLL Hell problem solved in .NET? Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.
5. What are the ways to deploy and assembly? An MSI installer, a CAB archive, and XCOPY command. 6. What is a satellite assembly? When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core applications are called satellite assemblies. 7. What namespaces are necessary to create a localized application? System.Globalization and System.Resources 8. What is the smallest unit of execution in .NET? An Assembly is the smallest. 9. When should you call the garbage collector in .NET? As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice. You can force garbage collector to run using System.GC.Collect(). 10. How do you convert a value-type to a reference-type? Use Boxing to convert. 11. What happens in memory when you Box and Unbox a value-type? Boxing converts a value-type to a reference-type, thus storing the object on the heap. Unboxing converts a reference-type to a value-type, thus storing the value on the stack. 12. Whats the implicit name of the parameter that gets passed into the class set method? Value and its data type depend on whatever variable were changing. 13. C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write? Two. Once you write at least one constructor, C# cancels the freebie constructor, and now you have to write one yourself, even if there is no implementation in it.
Additional Questions
1. What is the role of data provider? The .NET data provider layer resides between the application and the database. Its task is to take care of all their interactions. Examples: - SQL Server data provider - OLEDB data provider - ODBC data provider ADO.NET supports the following OLE DB Providers: - SQLOLEDB Microsoft OLE DB Provider for SQL Server - MSDAORA Microsoft OLE DB Provider for Oracle - Microsoft.Jet.OLEDB.4.0 OLE DB Provider for Microsoft Jet 2. Describe how a .NET application is compiled and executed. From the source code, the compiler generates Microsoft Intermediate Language (MSIL) which is further used for the creation of an EXE or DLL. The CLR processes these at runtime. Thus, compiling is the process of generating the MSIL. They way you do it in .NET is as follows: - Right-click and select Build / Ctrl-Shift-B / Build menu, Build command
3.
4. 5.
6. 7. 8. 9.
10.
14.
15.
- F5 compile and run the application. - Ctrl+F5 compile and run the application without debugging. Compilation can be done with Debug or Release configuration. The difference between these two is that in the debug configuration, only an assembly is generated without optimization. However, in release complete optimization is performed without debug symbols. Describe the role of inetinfo.exe, aspnet_isapi.dll and aspnet_wp.exe in the page loading process. inetinfo.exe is the Microsoft IIS server running, handling ASP.NET requests among other things. When an ASP.NET request is received (usually a file with .aspx extension), the ISAPI filter aspnet_isapi.dll takes care of it by passing the request to the actual worker aspnet_wp.exe. Whats the difference between Response.Write() and Response.Output.Write()? Response.Output.Write() allows you to write formatted output. What methods are fired during the page load? Init() when the page is instantiated. Load() when the page is loaded into server memory PreRender() the brief moment before the page is displayed to the user as HTML Unload() when page finishes loading What namespace does the Web page belong in the .NET Framework class hierarchy? System.Web.UI.Page Where do you store the information about the users locale? System.Web.UI.Page.Culture Whats the difference between CodeBehind = MyCode.apsx.cs and Src = Mycode.aspx.cs ? CodeBehind is relevant to Visual Studio.NET only. Whats a bubbled event? When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, ect.) is quite tedious. The controls can bubble up their event handlers, allowing the main DataGrid event handler to take care of its constituents. Suppose you want a certain ASP.NET function executed on MouseOver for a certain button. Where do you add an event handler? Add an OnMouseOver attribute to the button. Example: btnSubmit.Attributes.Add(onmouseover, soumeClientCodeHere();); What data types does the RangeValidator control support? Integer, String, and Date Explain the differences between Server-side and Client-side code? Server-side code executes on the server. Client-side code executes in the clients browser. What type of code (server or client) is found in a Code-Behind class? The answer is server-side code since code-behind is executed on the server. However, during the code-behinds execution on the server, it can render client-side code such as JavaScript to be processed in the clients browser. But just to be clear, code behind executes on the server, thus making it server-side code. Should user input data validation occur server-side or client-side? Why? All user input data validation should occur on the server at minimum. Additionally, client-side validation can be performed where deemed appropriate and feasible to provide a richer, more responsive experience for the user. What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other? Server.Transfer transfers page processing from one page directly to the next page without making a round-trip back to the clients browser. This provides a faster response with a little less overhead on the server.
16.
Server.Transfer does not update the clients url history list or current url. Response.Redirect is used to redirect the users browser to another page or site. This performs a trip back to the client where the clients browser is redirected to the new page. The users browser history list is updated to reflect the new address. Can you explain the difference between and ADO.NET Dataset and ADO Recordset? Valid answers are: - A DataSet is designed to work without any continuing connection to the original data source. - Data in a DataSet is bulk-loaded, rather than being loaded on demand. - Theres no concept of cursor types in DataSet. - DataSets have no current record pointer. You can use Foreach loops to move through the data. - You can store many edits in a DataSet, and write them to the original data source in a single operation. - Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources. What is the Global.asax used for? The Global.asax (including the Global.asax.cs file) is used to implement application and session level events. What are the Application_Start and Session_Start subroutines used for? This is where you can set the specific variables for the Applications and Session objects. Describe the difference between inline and code behind. Inline is code written alongside the html in a page. Code-behind is code written in a separate file and referenced by the .aspx page. Which method do you invoke on the DataAdapter control to load your generated dataset with data? The Fill() method. Can you edit data in the Repeater control? No, it just reads the information from its data source. Which template must you provide, in order to display data in a Repeater control? ItemTemplate. How can you provide an alternating color scheme in a Repeater control? Use the AlternatingItemTemplate. What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control? You must set the DataSource property and call the Databind method. What base class do all Web Forms inherit from? The Page class. Name two properties common in every validation control? ControlToValidate property and Text property. Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box? DataTextField Property. Which control would you use if you need to make sure the values in two different controls matched? CompareValidator control. How many classes can a single .NET DLL contain? It can contain many classes. What is ViewState? ViewState allows the state of objects (serializable) to be stored in a hidden field on the page. ViewState is transported to the client and back to the server, and is not stored on the server or any other external source. ViewState is used to retain the state of server-side objects between postbacks.
31. What is the lifespan for items stored in ViewState? Item stored in ViewState exist for the life of the current page. This includes postbacks (to the same page). 32. What does the EnabeViewState property do? Why would I want it on or off? It allows the page to save the users input on a form across postbacks. It saves the server-side values for a given control into ViewState, which is stored as a hidden value on the page before sending the page to the clients browser. When the page is posted back to the server, the server control is recreated with the state stored in viewstate. 33. What are the different types of Session state management options available with ASP.NET? ASP.NET provides In-Process and Out-of-Process state management. In-Process stores the session in memory on the web server. This requires the sticky-server (or no load-balancing) so that the user is always reconnected to the same web server. Out-of-Process Session state management stores data in an external data source. The external data source may be either a SQL Server or a State Server service. Out-of-Process state management requires that all objects stored in session are serializable.