INTERVIEW EASY

1.) What are the different types of caching?

Page output caching, Fragment and Data caching.

2.) What are the two main keywords used for authorization?

Allow and Deny

3.) How many types of Authentication modes available and what are they?

There are 3 types of authentication as follows:

• Windows
• Passport
• Form
  

3.) Explain the differences between Server-side and Client-side code?

Server side code will process at server side & it will send the result to client. Client side code (javascript) will execute only at client side

4.) How do assemblies find each other?

By searching directory paths. There are several factors which can affect the path (such as the App Domain host, and application configuration files), but for private assemblies the search path is normally the application’s directory and its sub-directories. For shared assemblies, the search path is normally same as the private assembly path plus the shared assembly cache.

5.) What are the cycle of methods when page load?

The Cylce of methods when page load will be the following

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

  ADO.NET

• 1.) Which namespace do you include while using ODBC connectivity?

  System.Data.ODBC.

  2.) How many objects does ADO.net have and what are they?

  ADO.net has 5 objects as follows:

  • Connection
  • Adapter
  • Command
  • Reader
  • Dataset.

  3.) State any 3 difference between ADO.NET and ADO?

• Recordset and Dataset
• Disconnected Architecture
• Lock Types
  

4.)what is Execute NOn Query?

Execute non Query is used to execute more than one command at the time (it is used for insert ,delete ,update) orthis method is invoked whenever DMLcommands has been excecuted

5.)What is @@rowcount and with small code snippet explain the usage?

@@rowcount gives the number of rows given as an result of previous query ran. Create procedure get_emp_count ( @emp_id int) As Select * from emp where emp_id =@emp_id If @@rowcount = 0 Begin Select 'no rows with emp_id= ' Select @emp_id End

6.)What provider ADO.net use by default?

no default provider

7.)what is data access layer?

Data Access layer is actually a part of Architecture layer. It has 2 tier,3 tier or N tier Layer. Generally we use 3 tier Layer 1) Presentation layer,Business Logic layer and then Data Access Layer. Data Access layer is a medium to talk between database and Business Logic layer. It helps to maintain flexibility,resuablity and even secuity also. In security SQL Injection can be stopped with 3 iter Archietcture.

8.)what is Sql Native Client?

SQL NATIVE CLIENT is a Provider used to Connect with the SQL Server database

9.)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 it’s not as fastest and efficient as SqlServer.NET.

C#

1.) What is the access limit of internal keyword?

Access inside the program or namespaces

2.) What is jagged array?

Its array of arrays. Arrays inside an array element.

3.) How do you prevent the class from being inheritance?

Simply include the keyword ‘Sealed’ in front of the class keyword.

4.) Tell C# syntax to catch any exception?

The Answer of the question as follows.A catch block that catches the exception of type System.Exception. can also omit the parameter data type in this case and just write catch {}.

5.)What does the term immutable mean?

The data value may not be changed. Note: The variable value may be changed, but the original immutable data value was discarded and a new data value was created in memory.

6.)What’s the advantage of using System.Text.StringBuilder over System.String?

StringBuilder is more efficient in cases where there is a large amount of string manipulation. Strings are immutable, so each time a string is changed, a new instance in memory is created.

7.)What’s the C# syntax to catch any possible exception?

A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

VB.NET

1.) How many views available in list view control and what are they?

4 views…

Large icon, small icon, Details and List.

2.) What is the use of ‘Preserve’ Keyword?

The preserve keyword helps to prevent data in an array from being lost.

3.) How do you prevent the class from being inheritance?

Simply include the keyword ‘NotOverridable’ in front of the class keyword.

4.) What is VB.Net

• VB.net is object oriented
• VB.Net can be used in Managed Code
• It supports inheritance, implement

5.) What is the base class of .net?

System.Object

6.) Differeces B/W VB.NET and C#(Coding)?

c# is case sensitive while VB.Net is case insensitive
c# is specifically targeted to programmers more efficient in C++, or Java its syntax is very much similar to java. While VB.Net is targeted for VB programmer and syntactically is very much similar to VB 6. with a much strong implementation of OOP modal
c# supports pointers ( although not recommended ) VB.Net does not.

7.) What is the difference between datagrid and gridview?

Datagrid is used in windows application and gridview is used in web and in datagrid we cannot write the code for datagrid properties where as for grid view w ecan write the code like template column item template etc this will not be done in datagrid

8.) What are the limitations of XML serialization?

XML serialization has some limitations. It converts public property values and fields, but does not encode type information. Also it does not encode private properties and fields, which requires binary serialization. Any class to be serialized to XML must have a public, parameterless constructor. One advantage of XML serialization is that the serialized data, being XML, rarely has any problems passing over networks and through security measures, such as firewalls, that might be unhappy with a binary data stream. For this reason, XML serialization is used by .Net Web services. Another advantage is that XML serialization is not platform-specific. In other words, you do not have to have .Net or Windows on both ends of the process.

9.) What is the difference between string class and stringbuilder class?

string class in immutable. Immutable is nothing but the value assigned to string cannot be changed. Stringbuilder class is mutable. mutable is nothing but the value assigned to stringbuilder can be changed.

10.) What are the Types of globalization we use?

when you want to use your application should run in differnet language like you have developed the application for english and should also run in dutch, french, japanese etc., then through globalization you can set lacal and culture for the each language in seperate folder. So that when the application will run for a specific region it will be show the content in same language.

11.) Is .Net Platform independent ?

As you all know that in .net there are different compilers like for c#-csc,vb-vbc etc after your code is complied it will convert to MSIL code which is independent this MSIL code will goes to CLR & this CLR is platform dependent i.e for unix platform you should have unix type of CLR ,for windows like the same so we can say that .net code is platform independent