Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Interview Questions in ASP.NET,C#.NET,SQL Server,.NET Framework

Nov 13, 2013
Here I am posting the interview questions whatever i have faced in my interviews
I have searched for so many websites and gathered information from my friends to answer the questions perfectly.

i think these questions are very helpful for the people who are trying to get the job on .NET
The most common question for experience persons is

Why would you like to change the company?

1) I am looking for a more challenging career in a firm with a larger employee base such as yours.
2) Keeping in mind my career goals, the time has come for me to move onto the next rung of 
the ladder and make a mark for myself. This can be achieved in a company like this.
3) It is just a career move to enhance my knowledge in my own area of interest.
After completion of this question only interview will go for further questions

Difference between stored procedure and function

1) Procedure can return zero or n values whereas function can return one value which is mandatory.
2) Procedures can have input, output parameters for it whereas functions can have only input parameters.
3) Procedure allows select as well as DML statement in it whereas function allows only select statement in it.
4) Functions can be called from procedure whereas procedures cannot be called from function.
5) Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
6) We can go for transaction management in procedure whereas we can't go in function.
7) Procedures cannot be utilized in a select statement whereas function can be embedded in a select statement.

Difference between Abstract and Interface

Abstract Class:

-Abstract class provides a set of rules to implement next class
-Rules will be provided through abstract methods
-Abstract method does not contain any definition
-While inheriting abstract class all abstract methods must be override
-If a class contains at least one abstract method then it must be declared as an “Abstract Class”
-Abstract classes cannot be instantiated, but a reference cannot be created
-Reference depends on child class object’s memory
-Abstract classes are also called as “Partial abstract classes”
-Partial abstract class may contain functions with body and functions without body
-If a class contains all functions without body then it is called as “Fully Abstract Class” (Interface)

Interface:

-If a class contains all abstract methods then that class is known as “Interface”
-Interfaces support like multiple inheritance
-In interface all methods r public abstract by default
-Interfaces r implementable
-Interfaces cannot be instantiated, but a reference can be created

Index types in SQL Server

Clustered Index

Only 1 allowed per table physically rearranges the data in the table to confirm to the index constraints for use on columns that are frequently searched for ranges of data for use on columns with low selectivity.

Non-Clustered Index

Up to 249 allowed per table creates a separate list of key values with pointers to the location of the data in the data pages For use on columns that are searched for single values 

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non-clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Included Column Index (New in SQL Server 2005) 

In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key columns to the leaf level of the non-clustered index. Non-key columns can help to create cover indexes. By including non-key columns, you can create non-clustered indexes that cover more queries. The Database Engine does not consider non-key columns when calculating the number of index key columns or index key size. Non-key columns can be included in non-clustered index to avoid exceeding the current index size limitations of a maximum of 16 key columns and a maximum index key size of 900 bytes. Another advantage is that using non-key column in index we can have index data types not allowed as index key columns generally.

In following example column Filename is varchar(400), which will increase the size of the index key bigger than it is allowed. If we still want to include in our cover index to gain performance we can do it by using the Keyword INCLUDE.

USE AdventureWorks
GO
CREATE INDEX IX_Document_Title
ON Production.Document (Title, Revision)
INCLUDE (FileName)

Non-key columns can be included only in non-clustered indexes. Columns can’t be defined in both the key column and they INCLUDE list. Column names can’t be repeated in the INCLUDE list. Non-key columns can be dropped from a table only after the non-key index is dropped first. For Included Column Index to exist there must be at least one key column defined with a maximum of 16 key columns and 1023 included columns.

Avoid adding unnecessary columns. Adding too many index columns, key or non-key as they will affect negatively on performance. Fewer index rows will fit on a page. This could create I/O increases and reduced cache efficiency. More disk space will be required to store the index. Index maintenance may increase the time that it takes to perform modifications, inserts, updates, or deletes, to the underlying table or indexed view.

Another example to test:

Create following Index on Database AdventureWorks in SQL SERVER 2005

USE AdventureWorks
GO
CREATE NONCLUSTERED INDEX IX_Address_PostalCode
ON Person.Address (PostalCode)
INCLUDE (AddressLine1, AddressLine2, City, StateProvinceID)
GO

Test the performance of following query before and after creating Index. The performance improvement is significant.
SELECT AddressLine1, AddressLine2, City, StateProvinceID, PostalCode
FROM Person.Address
WHERE PostalCode BETWEEN '98000'
AND '99999';
GO

Interview questions 

What are differences between Array list and Hash table?

Ans: 1) Hash table store data as name, value pair. While in array only value is store.
2) To access value from hash table, you need to pass name. While in array, to access value, you need to pass index number.
3) you can store different type of data in hash table, say int, string etc. while in array you can store only similar type of data.

What are differences between system.stringbuilder and system.string?

The main difference is system.string is immutable and system.stringbuilder is a mutable. Append keyword is used in string builder but not in system.string.
Immutable means once we created we cannot modified. Suppose if we want give new value to old value simply it will discarded the old value and it will create new instance in memory to hold the new value.

What are the differences between Application object and session object?

Ans: The session object is used to maintain the session of each user. If one user enter in to the application then they get session id if he leaves from the application then the session id is deleted. If they again enter in to the application they get different session id.
But for application object the id is maintained for whole application. 

What are the different types of indexes?

Ans: Two types of indexes are there one is clustered index and non-clustered index

How many types of memories are there in .net? 

Ans: Two types of memories are there in .net stack memory and heap memory

Is it possible to set the session out time manually? 

Ans: Yes we can set the session out time manually in web.config.

What are differences between function and stored procedure?

Ans:
1) Function returns only one value but procedure returns one or more than one value.
2) Function can be utilized in select statements but that is not possible in procedure.
3) Procedure can have an input and output parameters but function has only input parameters only.
4) Exceptions can be handled by try catch block in procedures but that is not possible in function.

What are the differences between Abstract and interface?

Ans:  

1) Abstract and interfaces cannot be instantiated but we can inherit.
2) Interface contain only declarations no definitions. Abstract contain declarations and definitions.
3) The class which contains only abstract methods is interface class. A class which contains abstract method is called abstract class
4) Public is default access specifier for interface we don’t have a chance to declare other specifiers. In abstract we have chance to declare with any access specifier

Can you Explain Page lifecycle in .net?
Can you Explain .NET architecture in .net?

What is the difference between primary key and unique key with not null?

Ans: There is no difference between primary key and unique key with not null.

What is boxing and unboxing concepts in .net? 

Ans: Boxing is a process of converting value type into reference type
Unboxing is a process of converting reference type to value type.

What are the differences between value type and reference type?

Ans: Value type contain variable and reference type are not containing value directly in its memory.

Memory is allocated in managed heap in reference type and in value type memory allocated in stack. Reference type ex-class value type-struct, enumeration

Is it possible to host the website from desktop?

Ans: Yes 

Why we go for page rendering in Asp.Net Page life cycle?

Ans: Browser understands an only html control that’s why in page rendering we will convert the aspx controls into html controls.

Write a sample query for self join?

Ans: Select e1.ename, e2.empid from emp e1, emp e2 where e1.empid=e2.mgrid;

Can we change the index of primary key on table?

Ans: No

How to change the name of the table or stored procedure in sql?

Ans: sp_rename oldtablename newtablename
For changing the column name
Sp_rename  ‘tablename.[Oldcolumnname]’,’newcolumnname’,’Column’
Ex:sp_rename ‘tblemp.first’,’namechange’,’Column’

How to find out which index is defined on table?

Ans: sp_helpindex tablename

Can you write the program to find the length of string without using library function?

Ans: for (int i=0; str[i]!=”\n”; i++)
{
Count++;
}

What is the difference between scope_identity() and current_identity()?

Ans: Scope_identity and current _identity both are similar and it will return the last identity value generated in the table.
Scope_Identity will return the identity value in table that is currently in scope

What are difference between GET and POST Methods?

Ans:
GET Method (): 

1) Data is appended to the URL.
2) Data is not secret.
3) It is a single call system
4) Maximum data that can be sent is 256.
5) Data transmission is faster
6) this is the default method for many browsers

POST Method (): 


1) Data is not appended to the URL.
2) Data is Secret
3) it is a two call system.
4) There is no Limit on the amount of data. That is characters any amount of data can be sent.
5) Data transmission is comparatively slow.
6) No default and should be explicitly specified.

What are difference between truncate and delete?

Ans: 1) Delete keep the lock over each row where Truncate keeps the lock on table not on all the row.
2) Counter of the Identity column is reset in Truncate where it is not reset in Delete.
3) Trigger is not fired in Truncate where as trigger is fired in Delete.
4) In TRUNCATE we cannot rollback.
5) In DELETE we can rollback

What is the difference Grid View and between Data Grid (Windows)?

Ans:
1) GridView Control Enables you to add sorting, paging and editing capabilities without writing any code.
2)GridView Control Automatically Supports paging by setting the ‘PagerSetting’ Property.The Page Setting Property supports four Modles 

a. Numeric(by default)
b. Next Previous
c. NumericFirstLast
d. Next PreviousLast

3)It is Used in asp.net
4)GridView Supports RowUpdating and RowUpdated Events.
5)GidView is Capable of Pre-Operations and Post-Operations.
6)GridView Has EditTemplates for this control
7)It has AutoFormat

DataGrid(Windows)

1)DataGid Control raises single Event for operations
2)DataGird Supports the SortCommand Events that occur when a column is Soted.
3)DataGrid Supports UpdataCommand Event that occurs when the UpdateButton is clicked for an item in the grid.
4)DataGrid is used in Windows GUI Application.
5)It doesnot have EditTemplates for this control
6)It doesnot have AutoFormat

If I write System.exit (0); at the end of the try block, will the finally block still execute?

Ans: No in this case the finally block will not execute because when you say system.exit(0),the control immediately goes out of the program, and thus finally never executes.

What are the different levels of State management in ASP.NET?

Ans:
State management is the process by which you maintain state and page information over multiple requests for the same or different pages.

There are 2 types State Management:

1. Client – Side State Management
This stores information on the client's computer by embedding the information into a Web page, a uniform resource locator (url), or a cookie. The techniques available to store the state information at the client end are listed down below:

a. View State – Asp.Net uses View State to track the values in the Controls. You can add custom values to the view state. It is used by the Asp.net page framework to automatically save the values of the page and of each control just prior to rendering to the page. When the page is posted, one of the first tasks performed by page processing is to restore view state.

b. Control State – If you create a custom control that requires view state to work properly, you should use control state to ensure other developers don’t break your control by disabling view state.

c. Hidden fields – Like view state, hidden fields store data in an HTML form without displaying it in the user's browser. The data is available only when the form is processed.

d. Cookies – Cookies store a value in the user's browser that the browser sends with every page request to the same server. Cookies are the best way to store state data that must be available for multiple Web pages on a web site.

e. Query Strings - Query strings store values in the URL that are visible to the user. Use query strings when you want a user to be able to e-mail or instant message state data with a URL.

2. Server – Side State Management
a. Application State - Application State information is available to all pages, regardless of which user requests a page.

b. Session State – Session State information is available to all pages opened by a user during a single visit.

Both application state and session state information is lost when the application restarts. To persist user data between application restarts, you can store it using profile properties.

Abstract Class:

Abstract class is a class which cannot be instantiated. Class should have “Abstract” key word with the name.  In any one of the method of class having abstract method with in it, then it should be define as abstract class. The class which derived the abstract class should have definition of the abstract method. These classes which derived the abstract class and implement the abstract methods call concrete class.

Abstract class may have the definition of function or may not.  Below is the simple example of an abstract class


public abstract class AbstractStudent
    {
        String Roll
        {
            get;
            set;
        }

        String FirstName
        {
            get;
            set;
        }
       
        String LastName
        {
            get;
            set;
        }
       

        Public String GetStudentDetails()
             {

                  // Implementation of Method   
             }

        public String SaveStudentDetails ()
            {
                  // Implementation of Method   
             }

        public abstract String CalculateWage();

    }
So, the class having one abstract method so we need to mention the class as "abstract" .

Difference between Abstract Class and Interface?

Abstract class is a class which cannot be instantiated and which can have methods with definition as well as declaration also. This can be inherited. 

As for Example:

public abstract class AbstractStudent
    {
        String Roll
        {
            get;
            set;
        }

        String FirstName
        {
           get;
           set;
        }
  
        String LastName
        {
           get;
            set;
        }

        Public String GetStudentDetails()
            {
                 // Implementation of Method  
             }

        public String SaveStudentDetails ()
            {
                  // Implementation of Method  
            }

        public abstract String CalculateWage();

    }


Interface can only contain the methods declaration and can be implemented in the class.

As for Example:


Public interface IStudnet
    {
        String Roll
        {
           get;
            set;
        }

        String FirstName
        {
            get;
            set;
        }
   
        String LastName
        {
            get;
            set;
        }
  
        String GetStudentDetails();
        String SaveStudentDetails ();
    }

Below are the few main difference between Abstract Class and Interface

a.    In abstract class method can have definition as well as declaration also. But Interface should have only declarations.
b.    All the Methods are Public as default and don’t have any access Modifier Controls in interface, whereas for abstract class we can have access modifier for methods.
c.    Abstract class can have constructor or destructor, whereas interface not.
d.    Abstract class can’t be part of multiple inheritance and we can implement multiple interface.

What do you mean by String objects are immutable?

String objects are immutable as its state cannot be modified once created. Every time when we perform any operation like add, copy, replace, and case conversion or when we pass a string object as a parameter to a method a new object will be created.

Example:
String str = "ABC";

str.Replace("A","X");

Here Replace() method will not change data that "str" contains, instead a new string object is created to hold data "XBC" and the reference to this object is returned by Replace() method.

So in order to point str to this object we need to write below line.
str = str.Replace("A","X");
Now the new object is assigned to the variable str. earlier object that was assigned to str will take care by garbage collector as this one is no longer in used.

What is dll hell problem in .NET and how it will solve?

Ans: Dll hell, is kind of conflict that occurred previously, due to the lack of version supportability of dll for (within) an application
.NET Framework provides operating system with a global assembly cache. This cache is a repository for all the .net components that are shared globally on a particular machine. When a .net component installed onto the machine, the global assembly cache looks at its version, its public key and its language information and creates a strong name for the component. The component is then registered in the repository and indexed by its strong name, so there is no confusion between the different versions of same component, or DLL

What is a Partial class?

Ans: Instead of defining an entire class, you can split the definition into multiple classes by using partial class keyword. When the application compiled, c# compiler will group all the partial classes together and treat them as a single class. There are a couple of good reasons to use partial classes. Programmers can work on different parts of classes without needing to share same physical file
Ex:
Public partial class employee
{
Public void somefunction()
{
}
}
Public partial class employee
{
Public void function ()
{
}
}

What is difference between constants, read-only and, static?

Constants: The value can’t be changed
Read-only: The value will be initialized only once from the constructor of the class.
Static: Value can be initialized once.

What is the cross page post backing?

Asp.Net 2.0 fixed this with built-in features that allowed us to easily send information from one page to another.

Button control has property PostBackUrl that can be set to URL of any page in our ASP.Net WebSite where we want to transfer all form values to.
Along with that Asp.Net 2.0 Page class has a property PreviousPage that allows us to get reference to the Page object that initiated the postback (in other words to get the actual reference to the Page object of the aspx page on which user clicked the Submit button on a HTML form).

So for example lets create two sample pages in our Web Application:  
  • SourcePage.aspx
  • DestinationPage.aspx
In SoucePage in Html form we will put two TextBox controls (one for First Name and one for Last Name) and one Button component  and set its PostBackUrl property to "~/DestinationPage.aspx".

SourcePage.aspx:
    <form id="form1" runat="server">
        <div>
            First Name:&nbsp;<asp:TextBox ID="FirstName" runat="server"></asp:TextBox><br />
            Last Name:&nbsp;<asp:TextBox ID="LastName" runat="server"></asp:TextBox><br /><br />
            <asp:Button ID="Button1" runat="server" Text="Submit To Destination Page" PostBackUrl="~/CrossPagePostbacks/DestinationPage.aspx" />
        </div>
    </form>

When our user clicks the Submit button, all the values from the HTML Form on SourcePage.aspx will be transfered to the DestinationPage.aspx and we will also be able to get reference to the SourcePage.aspx in our DestinationPage with the PreviousPage property like this:

So in our DestinationPage.aspx.cs code-behind we can easily access two TextBox controls on SourcePage.aspx and show them in two label controls like this:
    protected void Page_Load(object sender, EventArgs e)
    {
        // first check if we had a cross page postback
        if ( (PreviousPage != null) && (PreviousPage.IsCrossPagePostBack) )
        {
            Page previousPage = PreviousPage;
            TextBox firstName = (TextBox)previousPage.FindControl("FirstName");
            TextBox lastName = (TextBox)previousPage.FindControl("LastName");
            // we can now use the values from TextBoxes and display them in two Label controls..
            labelFirstName.Text = firstName.Text;
            labelLastName.Text = lastName.Text;
         }
    }

You probably noticed that we first checked if PreviousPage property of current page (DestinationPage.aspx) is NOT NULL, this is done to avoid running our code in case that user opens our DestinationPage.aspx directly, without running a cross page postback.

Also here we checked the another PreviousPage property called IsCrossPagePostBack to see if we really had a CrossPagePostback.
(If Server.Transfer is used to redirect to this page, IsCrossPagePostBack property will be set to FALSE.

TIP: We can be completely sure that we have a  real CrossPagePostback ONLY IF:
  1. Page.PreviousPage is NOT NULL,
  2. PreviousPage.IsCrossPagePostback is true
This important to check to avoid errors in code.

Now this is very useful and i'm sure you are eager to use this in your next project. But wait, we are not over yet!

Finding the controls on PreviousPage with FindControl method and type-casting them from object to their real type is a little messy.
It feels like there must be a better solution for this!

And here it is: We can use the <%@ PreviousPageType %> directive in the header of our DestinationPage.aspx like this
    <%@ PreviousPageType VirtualPath="~/SourcePage.aspx" %>

to declare our previous page type, and then we can access Public properties of the PreviousPage without typecasting.
Now all we need to do is to create some public properties on our SourcePage.aspx.cs to expose data/Controls we want to the destionation page:
    public partial class SourcePage : System.Web.UI.Page
    {
        public string FormFirstName
        {
            get { return FirstName.Text; }
        }

        public string FormLastName
        {
            get { return LastName.Text; }
        }
    }

And then we can change the Page_Load code in our DestinationPage.aspx to much cleaner code like this:
    protected void Page_Load(object sender, EventArgs e)
    {
        // first check if we had a cross page postback
        if ( (PreviousPage != null) && (PreviousPage.IsCrossPagePostBack) )
        {
            SourcePage prevPage = PreviousPage;

            // we can now use the values from textboxes and display them in two Label controls..
            labelFirstName.Text = prevPage.FormFirstName;
            labelLastName.Text = prevPage.FormLastName;     
        }
    }

SourcePage type used in the code is offcourse name of the partial class defined is SourcePage.aspx.cs that inherits System.Web.UI.Page that is automatically created for us when we created new WebForm in VisualStudio.

This code is much cleaner and easier to follow, there is no ugly typecasting, just simple property values to use to retrieve the data from previous page.


When should you use Abstract Class vs Interface while programming?

 Ans: When we want that sub class must implement all the methods of base class. In such a situation we will implement the interface. In the other hand when we want only some method of base class in our sub class then use base class as abstract class.

What is the difference between application exception and system exception?

Ans: The difference between application exception and system exception is that system exceptions are thrown by CLR and application exceptions are thrown by applications.

What is the difference between authorization and authentication?

Ans: Authorization is a process of allowing or denying resources to particular user or record 

Declaration of authorization is

<authorization>
<allow users=”Suresh, Sanjay”/>
<deny users=”Ramana, Rakesh”>
</authorization>
Sometimes authorization allows the unauthorized persons at that time we will use
<deny users=”?”/>

Authentication means

Authentication is a process where we identify the credentials of user i.e. username, password and create an identity to mention user as an authenticated.  

What is the use of n-tier architecture and 3-tier architecture?


Check this article for 3-tier architecture 3 tier architecture example in asp.net

How to get the version of the assembly?

Ans: lbltxt.text=Assembly. GetExecutingAssembly().GetName().Version.ToString();

What is the location of Global Assembly Cache on the system?

Ans: c:\Windows\assembly

 What is the serialization?

Ans: Serialization is a process of converting object into a stream of bites.

What is synchronization?

Ans: The mechanism needed to block one thread access to the data. If the data is being accessed by another thread.
Synchronization can be accessed by using system.monitor class
A monitor class methods are enter, exit, pulse for this lock statement is also used
Suppose if we need to synchronize some data at that time we need to place that data in this block
Lock
{
}
Whatever the data has been placed into the lock block that data has been blocked

What are the thread priority levels?

Ans: Thread priority levels are five types
         0 - Zero level
         1 - Below Normal
         2 - Normal
         3 - Above Normal
         4 - Highest
By Default priority level is 2

What is the difference between .tostring(), Convert.tostring()?

Ans: The basic difference between them is “Convert” function handles NULLS while
“.ToString()” does not it will throw a NULL reference exception error. So as a good coding
practice using “convert” is always safe.

What is Collation?

Ans: Collation refers to a set of rules that determine how the data is sorted and compared.

What is the difference between Primary key and unique key?

Ans: Primary key does not allow the null values but unique key allows one null value.
Primary key will create clustered index on column but unique key will create non-clustered index by default.

How many web.config files are there in 1 project?

Ans: There might be multiple web.config files for a single project depending on the hierarchy of folders inside the root folder of the project, so for each folder we can use one web.config file

What is the difference between throw and throw ex?
What is the difference between view state and hidden field?

Ans: viewstate is secured hidden field is insecure
Viewstate will store large amount of data but hidden filed will store small amount of data. 

What is the difference between binary serialization and xml serialization?
What is the Difference between read only and constant variables?

Ans: Read only can assign the values at runtime only.
Constant will assign the values at compile time only.
We cannot modify the both variable values.

What is static keyword in .Net?

Ans: Static is same as constant variable but we can change the value of static variable and we can access the variables without creating any instances

What is the use of business logic layer in 3-tier architecture in .net?

Ans: Though a web site could talk to the data access layer directly, it usually goes through another layer called the business layer. The business layer is vital in that it validates the input conditions before calling a method from the data layer. This ensures the data input is correct before proceeding, and can often ensure that the outputs are correct as well. This validation of input is called business rules, meaning the rules that the business layer uses to make “judgments” about the data.

However, business rules don’t only apply to data validation; these rules apply to any calculations or any other action that takes place in the business layer. Normally, it’s best to put as much logic as possible in the business layer, which makes this logic reusable across applications.

One of the best reasons for reusing logic is that applications that start off small usually grow in functionality. For instance, a company begins to develop a web site, and as they realize their business needs, they later decide to add a smart client application and windows service to supplement the web site. The business layer helps move logic to a central layer for “maximum reusability.”


What happens when I enter a URL in my browser and click enter?

You type in the URL and hit go. The browser needs to translate that URL www.somesite.com into an IP address so it knows what computer on the internet to connect to (That URL is just there to make it easier for us humans - kinda like speed-dial for phone numbers I guess). So your browser will see if it already has the appropriate IP address cached away from previous visits to the site. If not, it will make a DNS query to your DNS server (might be your router or your ISP's DNS server) - see http://en.wikipedia.org/wiki/Domain_name… for more on DNS. Once your browser knows what IP to use, it will connect to the appropriate webserver and ask for the page. The webserver then returns the requested page and your browser renders it to the screen.

The firewall will control connections to & from your computer. For the most part it will just be controlling who can connect to your computer and on what ports. For web browsing your firewall generally won't be doing a whole lot.

Your router (see http://en.wikipedia.org/wiki/Router ) essentially guides your request through the network, helping the packets get from computer to computer and potentially doing some NAT (see http://en.wikipedia.org/wiki/Network_add… ) to translate IP addresses along the way (so your internat LAN request can be transitioned onto the wider internet and back).

IP Addresses (see http://en.wikipedia.org/wiki/IP_address ) are unique addresses for computers that basically allow computers to find each other. Think of the IP address as a computer's well address or phone number, you've got to know someone's phone number before you can call them and you've got to know a computer's IP address before you can connect to it. Going back to the start - that's what those URLS and DNS make possible, you don't know John Doe's phone number so you look in the phone book; likewise your computer doesn't know yahoo.com's IP address so it looks in DNS.

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email

360 comments :

«Oldest   ‹Older   201 – 360 of 360   Newer›   Newest»
Anonymous said...

thank u

karuna said...

thhh

Sachin Bhattad said...

Thank you Suresh Sir for this valuable information. It is great help for fresher like me...

Jagdish Yadav said...

Thanks and becuase of you guys we freshers are here...thanks

shijo said...

This is very helpful thank you

Neelu said...

That's a pretty good information.
Thank you so very much!!

Anonymous said...

Niceeeeeeeeeeeeeeeeeeeeee...............

Anonymous said...

Good example Suresh.
Put some MVC related content.

Thanks
Neeraj

Leena Kulkarni said...

Its really nice..thanks

Anonymous said...

Wow Superb ....Ji Why u do not have 'Linkedin' option in your follow list...

vishvajeet pawar said...

thanks

vnk said...

Thanks ......u so much

Jose said...

very good one .. Thank You

Anonymous said...

goog notes

ASP.NET said...

Thank you for sharing.. :)

azad khan said...

Thnkuuuuuuuuu soooo much sir :-)

Anonymous said...

Thank you so much sir for your valuable information.It helps a lot for freshers :)

Anonymous said...

Sir can you send me more interview question with answers for 3 years experience candidates. My email id is sumi2987@gmail.com

Anonymous said...

good one

asp.net interview questions said...

thanks for sharing interview questions.. i got scared before seeing your post.. because tomorrow is my interview.. bless me guys

Anonymous said...

thanku

chintu said...

Thank U very Much Its AwS0m3

Anonymous said...

Wow its a good Blog, people can remember all concept in one short :)


Amit Singh Chandel
Pune

Kadir Ansari said...

Thanks a lot..............

GOWTHAM D S said...

No Words to say. Its simply awesome. Thanks a lot such an wonderful article.

Ashaar Mohamed said...

Abstract cannot be instantiated but we can inherit. Interface it cannot be inherit it can be instantiate

I think both Interface and Abstract class we can't instantiate, please correct above your answer if I am not wrong.

Anonymous said...

vERY uSEFUL. tHANK yOU.

Vijay Paunikar said...

nice post...... but one que sir.....
stored Procedure ??if there are two statements in Procedure then how can we take both result set in datareader?
Please try to understand them.Thank you.

lakshmi suresh said...

this qusetions are very helpfull for me i am .net fresher can give the download link for this qus o

Anonymous said...

nice post thank you sir

Gopal Sharma said...

What are difference between truncate and delete?

Hi All
Some document is not updated for above question. From sql Server 2005 onwards Truncate also rollback.
Main difference between truncate and delete is as below

Truncate is non condition query but delete can be.
Truncate reset the identity column.
If we make reference from a table then that table can't be truncated even if there is no row in child table
i,e We have xtDepartment with (DepartmentID, DepartmentName) and xtEmployee (Empid, EmpName, DepartmentId). xtEmployee as foreign key on DepartmentId referenced from xtDepartment . Even there is no row or record in xtEmployee but you can't truncate xtDepartment

Anonymous said...

toooo goood!!!!!

S Sarthak said...

Very Nice set of questions and easily understandable answers.... thanks a lot to Suresh... please be supporting your junior's like this

Madhu Mattapalli said...

good

Mukesh Kumar said...

sir plz give me some idea of constructor or deconstructor

Anonymous said...

Seriously u done a good job....its very useful ...i ve attended 2 interviews dey asked these perfect questios !!!! atlast i found a good ansers from u !!! thank u !!!

Anonymous said...

thanx suresh! You have collected so many root questions in one place to enough to crack any interview!

Anonymous said...

these question are very nice.
i have a query.. what is the difference between typed and untyped in asp.net

Anonymous said...

Really Helpful post.... thanx...

Preeti Chavan said...

Hii sir ....
I want to Add Comments on image like facebook.... How can i do this...??? please help me....

Anonymous said...

thanks a lot ..................

Amit Kumar said...

code for getting length of string is wrong.
correct code
foreach(char x in str)
{

count++;
}

NageswaraRao Pendela said...

Thanks for providing neddful information. it is very helpful for interviews. please keep posting new questions

Manikandan k said...

nice.... Simple....

V G S Naidu said...

How can it be supposed to true like the statements " -Interfaces can be instantiated, but a reference cannot be created"
i heard that , for abstract classes and Interfaces we could not instatniated them.

Anonymous said...

Guudd job suresh.....
Abm

Anonymous said...

really very nice and helpfull Thanks a lot :)

Anonymous said...

find the length of string without using library function
according to your code:
String str="helloo World";
for (int i=0; str[i]!=”\n”; i++)
{
Count++;
}

Index was outside the bounds of the array

and Right Code is:
string test = "Hello World";
int counter = 0;
foreach (char c in test)
{
counter++;
}
Response.Write(counter);

sami akhtar said...

its Awsommmmmmmmmmmmeeeeeeeeee............

Purav Patel said...

Great question

Unknown said...

Great post

Prakash Singh said...

great work done thanks for that...

Dot Net said...

good site

Anonymous said...

Thanks for sharing
Some good questions are can also be found at http://goo.gl/iWftQS

Thanks,
Jobs Junction

Anonymous said...

Thanks for Share with Freshers in Interview Questions,
Link as,
dotnettrainingchennai

Anonymous said...

good questions, keep posting more questions..

deb said...

Great. Keep it up...!

Anonymous said...

select top 4 * from

Anonymous said...

Thank you sir

Anonymous said...

its awesome....
Thanks ...

Raghavendra Doranalli said...

Sir, your are doing great job.........!

Fans said...

Fantastic post. It is very useful to prepare for interview. Thanks.

George said...

Thanks for the share.

Anonymous said...

Thanks. Good to revise. I cracked interview. Thank u soo much

sameerbaig said...

It is such a gr8 article that u've been provided to us.
Thanks 4 ua post and keep posting the article.
It really assist to learn something like dis...

Anonymous said...

very very important questions for the interview

Anonymous said...

Difference between ArrayList and HashTable is not right.....You write difference between array and hash table.....

Balaji Bala said...

thanks

Anonymous said...

Very good collection

Anonymous said...

Thank You so much for posting such a important concepts

Anonymous said...

great post

Srii said...

Thanks for the wonderful question that helps us crack difficult interviews!!

Srii said...

Thanks for the great tips. These questions would be very well useful to crack interviews!

Lisa Edward said...

Awesome tips to clear interviews!

Anonymous said...

very nice information..Thanks a lot...........

Archie said...

Good that you have posted some interesting questions asked in interviews.

But there are faults in some of the answers given :

For the query about GET POST methods, you mentioned data is secret for post. That is WRONG. Data is not secret unless it is https or if we are using sessions.

For GET you have mentioned max data sent is 256. This is also Wrong. Data sent by a Get depends on the browser which supports upto 4K of data.

I would like to know how GET transmission is faster than a POST method.

There are few glitches in explanation of abstract vs interface, which has been reported already by few readers over here.

Anonymous said...

hhhhhhhhhhhhhhhhhhhhhhhhhhhhh

Anonymous said...

superb...

Anonymous said...

useful post . thanks

Anonymous said...

awesome

Sibin K T said...

Nice article. These are the regular question towards software engineers having 2+ year experience

Anonymous said...

dd

Anonymous said...

thank you sooooooooooooo much
by Bijulal

Anju Renjith said...

Excellent

Anonymous said...

thank u

Anonymous said...

Interface it cannot be inherit it can be instantiate

Jenny Peter said...

Thanks

Anonymous said...

thanks nice post
but there are some wrong answer
like:Interfaces can be instantiated, but a reference cannot be created

Anonymous said...

thanks a lot,these questions r very helpful

Anonymous said...

Its good but not clearly define all differences in answers.

Anonymous said...

Very nice article..
Thanks for your great efforts.. :)

Anonymous said...

nice post...

Anonymous said...

very nice compilation..thank you!

ranganath ranga said...

thank you so much, but i want some more questions for 1+ year of experience interview

Zeeshan Anwer said...

Thanks
for this interview practice link this is awesome good

Anonymous said...

hi

Lakshmi said...

Useful Article

Anu Sri said...

Really nice answers. Read most of them and I really liked it. So thanks for sharing.

Pushpam Abhishek said...

sir,plz send some tutorils of asp.net mvc
emial id-pushpambhshk@gmail.com

Bhavesh Patel said...

Greate job.

anil kumar sharma said...

sir you are at the point.
interface can be instantiate but reference cant be created.
but the actual thing is that you cant create instance of a interface but can create a reference of interface.
please check it..

Umesh said...

Nice Questions , it will really help for us

Saurabh Chauhan said...

please correct some places where you have mention that interfaces can only have definitions (it should be declaration) and many places have wrong information may be by mistake rest are good work

MITHUN M said...

what do you mean by "Is it possible to host the website from desktop" ?

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Prabhakar Bharti said...

Thanks dude forwonderfull article which is simple n easy to understand this article.

Unknown said...

dear sir i am preparing these questions for my first interview please tell me more about asp.net c# related questions .send me a feedback on my email id

my eamail id is : deepaksingh.thakur791@gmail.com

Chintan Dalwadi said...

Can we change the index of primary key on table?

Ans: No

Please correct this answer . We can change index.

Anonymous said...

ratooo popat

Unknown said...

really It is so helpful brother .... thanks allot

Vakeel Mansoori said...

nice post sir

Anonymous said...

thank you very much

Kix Mr said...
This comment has been removed by a blog administrator.
Diya Patel said...

Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
QTP Training in Chennai

Johnson Frank said...

Thank u so much.. I really helpful to tune my mind once again.

swathi vullangi said...

nice article helping allot but there is a question like difference between arraylist and hash table but the answer was wrong

Unknown said...

nice post for interview

ashwani agrawal said...

really suresh its awesome experience to visit on ur blog ...i really enjoy and learn more and i make sure its the best ewxperience of mine to visit on ur blog....so thanks for give to all inteview quesion thanks again

a.m.sathish a.m. said...

Very good job dude,easy to learn
Anyway Thanks

preeti pal said...

I think answer of this question is wrong
What are differences between Array list and Hash table?
in this you define array not the array list.please update the correct answer.

Subhankar Maiti said...

Abstract class can't be instantiate. If any way to create please update.

Er.Manish Saini said...

Yes these are very ver nice questions thanks for your post

Anonymous said...

Firstly thanks for sharing these questions.

In the question
Q)What are differences between Array list and Hash table?

3rd Point - it should be "Any datatype can be stored in the arraylist"
You have written about array

http://www.aspdotnet-suresh.com/2013/09/difference-bw-array-and-arraylist-in-csharp-example.html

Unknown said...

thanks very helpful...

Anonymous said...

Thank you....

heena bhalodia said...

Thanx for posting this interview question.can you post interview question for MVC,jquery,angular js.

Anonymous said...

Hi ,

Your statement on the question of difference between procedure and function .

I think one statement is wrong in this , pls clarify .

4) Functions can be called from procedure whereas procedures cannot be called from function. ( i think procedure can be called from fuction .) .

Verify me in santanukmohapatra@gmail.com

192.168.1.1 said...

nice! thank you so much! Thank you for sharing. Your blog posts are more interesting and impressive. I think there are many people like and visit it regularly, including me.

Siva Krishna said...

Please post updated interview questions

Omprakashpanwar said...

thanks a lot sir.
it give confidence to face an interview.

Unknown said...

Thanks to share this knowladge

sagainfosoft said...

Thanks for Interview Questions

Unknown said...

Good questions!!

yatendra parashar said...

Good article sir keep it up

Selva Ganesh said...

nice post

Unknown said...

nice post

Anonymous said...

please write about array list not array array list have not need size define it is hold
different type data. we search data by index.

hash table store data with key and values we get data by key

What are differences between Array list and Hash table?

Ans: 1) Hash table store data as name, value pair. While in array only value is store.
2) To access value from hash table, you need to pass name. While in array, to access value, you need to pass index number.
3) you can store different type of data in hash table, say int, string etc. while in array you can store only similar type of data.

viral jain said...

Can you give me the link where you explain about triggers in SQl?

Panuganti Srinivasarao said...

very nice article for .net people

Arun said...

Intresting

Shrikant Jadhav said...

Awesome 😎 great job dude

Narendra said...

dear think the line ,"Abstract classes cannot be instantiated, but a reference cannot be created" does'nt have any sense ..

Suresh said...

Good set of questions.

Anonymous said...

thanks but please add more questions.

renuka desai said...

Thanks for the interview-questions. Wonderful collection to crack the interview.

renuka desai said...

Thanks for the interview-questions. Wonderful collection to crack the interview.

Anonymous said...

Nice

Sutharson Prabakaran said...

Thanks a lot.

Ankit Ojha said...

Question no 3 is What are differences between Array list and Hash table?

and your answer about differences between Array and Hash table.
may be i am wrong but please check

Unknown said...

really , almost all the topics has covered......thank you the team who has made this..

Unknown said...

Hi Suresh,
Thank you for the post.But in "What are differences between Array list and Hash table?"
You are defining diff b/w array and hash list. can you please check if I am not wrong.
Thanks

Aanish Gaur said...

primary key does not allow null values.
unique key allow only one null vlues.
primary key create clusterd index automatic.
unique key create multiple clustred index.

Aanish Gaur said...

how we can access parent class functionality in child class? can anyone explain it?

Rashmi said...

Thanks for info.Very helpful..

Anonymous said...

very useful one and awesome

«Oldest ‹Older   201 – 360 of 360   Newer› Newest»

Give your Valuable Comments

Other Related Posts

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.