Technical Interview Questions
.Net & .Com Interview Question
.Net Web Interview Questions
.Net Interview Questions
C# Interview Questions
                              .........More

Soft Skills
Communication Skills
Leadership Skills
                              .........More

.Net Database Interview Questions and Answers

How can you deploy an asp.net application ?
You can deploy an ASP.NET Web application using any one of the following three deployment options.
a) Deployment using VS.NET installer
b) Using the Copy Project option in VS .NET
c) XCOPY Deployment

Explain similarities and differences between Java and .NET?
Comparing Java and .NET is comparing apples and oranges. Either the question needs to be to compare Java and C# or J2EE and .NET.

What are the XML files that are important in developing an ASP.NET application?
The XML file necessary for the for developing an asp.net application is Web.config

Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
Declare the variables in Global.aspx

How many objects are there in ASP?
Answer1
8 objects, they are request,response, server,application,session,file, dictionary, textstream.

Answer2
There are 6 objects in ASP.net
a) Server
b) Session
c) Application
d) ObjectContext
e) Response
f) Request

Which DLL file is needed to be registered for ASP?
The dll needed for the ASP.net is SYSTEM.WEB.dll


Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you do pating?

Use DataGrid control which has in-built paging features for the purpose.

What does Server.MapPath do?

Answer1
srver.mappath() maps the path given in the argument to the server’s physical path.

Answer2
It returns the complete(absolute) path of the file used in parameter.

Answer3
It returns a string containing the physical path in the server’s file system that corresponds to the virtual or relative path specified by the Path argument.

Name atleast three methods of response object other than Redirect.
Answer1
a) Response.Clear( )
Clears the content of the current output stream.
b) Response.Close( )
Closes the network socket for the current response.
c) Response.End( )
Stops processing the current request and sends all buffered content to the client immediately.

Answer2
methods of Response is Redirect a. Transfer

Name atleast two methods of response object other than Transfer.
a) Response.ClearContent( )
Clears the content of the current output stream.
b) Response.ClearHeaders( )
Clears the HTTP headers from the current output stream.

What is State?
It is the property of the web forms.
ASP.NET provides four types of state:
Application state
Session state
Cookie state
View state.

Explain differences between ADO and DAO.
dao- can access only access database
ado- can access any databases


How many types of cookies are there?

2 types, persistant and impersistant.

How many types of cookies are there?
Answer1
Two type of cookeies.
a) single valued eg request.cookies(”UserName”).value=”Mahesh”
b)Multivalued cookies. These are used in the way collections are used.
e.g.
request.cookies(”CookiName”)(”UserName”)=”Mahesh”
request.cookies(”CookiName”)(”UserID”)=”ABC003?

rember no value method in multivalued cookie

Answer2
There are two types of cookies:
Session cookies
Persistent cookies

Tell few steps for optimizing (for speed and resource) ASP page/application.
Avoid mixing html code with asp code

Which command using Query Analyzer will give you the version of SQL Server and Operating System?
@@VERSION
Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

How to find the SQL server version from Query Analyzer ?
Answer1
To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement:
SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
The results are:
• The product version (for example, “9.00.1399.06?)
. • The product level (for example, “RTM”).
• The edition (for example, “Enterprise Edition”).
For example, the result looks similar to:
9.00.1399.06 RTM Enterprise Edition

How to determine which version of SQL Server 2000 is running
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code:
SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
The results are:
• The product version (for example, 8.00.534).
• The product level (for example, “RTM” or “SP2?).
• The edition (for example, “Standard Edition”). For example, the result looks similar to
:
8.00.534 RTM Standard Edition

Answer2
One can also use SELECT @@Version where the result would look like
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Page Numbers :   1         2         3         4         5

Have a Question ? post your questions here. It will be answered as soon as possible.

Check Microsoft .Net Interview Questions for more Microsoft .Net Interview Questions with answers

Check Asp .Net Interview Questions for more Asp .Net Interview Questions with answers

Check .Net Deployment Interview Questions for more .Net Deployment Interview Questions with answers