Satyam Interview Question Answer

Satyam
IS MS.Net platform independent or dependent?
.Net is not platform independent , it's only language independent
What is the main Difference Between .Net 2003 and .Net 2005.and also
Asp1.1,Asp2.0 and Asp3.0
Difference b/w .net 2003 & .net 2005
vs.net2003 doesn’t carry personal webserver.whereas vs2005 will
carrying personal web server called asp.net development server
Vs.net2003 will create set of different files for asp.net
applications. this makes development complex.Whereas in vs.net2005
will support project less appln developement.for asp.net this will
create only required files for asp.net appln. This makes development
easier.
2003 will support only code-behind tech.whereas 2005 will support in-
page tech and code behind tech.
2003 only support one language for WebPages with in asp.net appln,
whereas 2005 will support different languages for WebPages with in
asp.net appln.
Which is the best way for keeping the data in XML or SQL server..and
why?
To store the data, the best and appropriate way is SQL SERVER as it is more compatible with any language and gud database.i think for a short term XML also plays vital role in storing the data.
What does the term immutable mean?
it means that this object can't be changed.but if you want another value to the same object another instance of the object is created and leave the current instance unchanged.an example of immutable is STRING.
What does the keyword virtual mean in the method definition?
The method can be over-ridden.
What are advantages of Stored Procedures?
Stored Procedure's are precomplied one. When ever you call a stored procedure it generate the result faster than ordinay coding. The improve the performance of the application i.e to reduce the time stored procedure's are used
Explain the usage of WHERE CURRENT OF clause in cursors ?
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor.
how to implement locking in sql server?
no need to impliment locks sql server automatically holds locks.
Difference between Cluster and Non-cluster index?
clustered index is physically stored a table can have 1 clustered
index
non clustered index is logically stored a table can have 249 non
clustred index
what is web server?
web server is a software which is responsible to execute server side script such as asp,php and etc.and send a html page to client.so finally we can say that web server is use for execute script(server side) and response send to client.
How to refresh the crystal report from the application ?
calling crystalreportcontrolname.reset (by selecting Report menu under
Refresh the report menuitem at design time)will refresh the report.
crystalreport1.DiscardSavedData=True
can i use two web.config files of ConnectionString in One Default.aspx
page?
we can have more than one web.config file in an application. We can have web.config file for every folder in application.but not 2 web.cofig in one place.
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 client's browser. This provides a faster response with a little less overhead on the server, Server.Transfer does not update the clients url history list or current url.
Response.Redirect is used to redirect the user's browser to another page or site. This performas a trip back to the client where the client's browser is redirected to the new page. The user's browser history list is updated to reflect the new address.
Dategrid filtering and sorting How can we sort all the fields at once?
Undoubtedly u need to write a sql query for this with the order by (or) sort by.And also call the subroutine that fills the datagrid after each insert or delete so that u can see the changes at the runtime with the new alignment(i mean sorting)...
What are generics? why it is used? architecture of ASP.NET?
Generics are new in .NET 2.0.It is used to define a type while leaving some details unspecified.Generics are the replacement of "Objects" in .NET1.1 Generics reduces the run-time error and increases the performance.
what are the attributes of sitemapnode?
Title,url,description
How do you make your site SSL enabled ?
ssl-secure sockets layer:
If you want user certificate authentication enabled, figure out who should have access to your site, and how to distinguish this group from all other users. Some examples of groupings:
Fermi people (i.e., FNAL.GOV Kerberos domain users eligible for KCA certificates) DOE-affiliated people (i.e., anyone who has DOEGrids certificate) Specific individuals with certificates from a known set of CAs
Anyone with a certificate issued by a particular CA and connecting from a particular domain (e.g., fnal.gov)Some combination of the above.
What is CTS, CLS and CLR ?
Common Type System(CTS) :A fundamental part of the .NET Framework's Common Language Runtime (CLR),the CTS specifies no particular syntax or keywords, but instead defines a common set of types that can be used with many different language syntaxes.
Common Language Specification(CLS):The Common Language Specification (CLS) describes a set of features that different languages have in common.The CLS includes a subset of the Common Type System (CTS).
The CLR is a multi-language execution environment
If cookies is disabled in client browser will session work ?
Sessions are normally tracked with cookies. However, clients are not required to accept cookies. Furthermore, you can turn off the use of cookies for session tracking altogether in the Web Application Server Control Panel.However when cookies are turned off or cookies are not enabled on a specific client computer, the server must work harder to track the session state, which has a performance impact. The recommendation is to leave cookies on and let the server automatically fall back to the cookieless operation only when required by a specific client connection.
When a session is created by the server, some information is automatically stored in it - the session ID and a timestamp. as an application developer, you can also store other information in the session in order to make it available to subsequent requests without explicitly passing it to that request.
About Global.asax ?
Global.asax is a file that resides in the root directory of your application. It is inaccessible over the web but is used by the ASP.NET application if it is there. It is a collection of event handlers that you can use to change and set settings in your site. The events can come from one of two places - The HTTPApplication object and any HTTPModule object that is specified in web.confg or machine.config. We will be covering both here.
it contains 7 events....
1.Application start
2.Application End
3.Session on start
4.Session on end
5.Session on Request
6.Application on Begining request
7.Application on Error
About writing a query and SP which is better ?
sp is the better one...
Its compile and inside that we can write any number of Query Statement , finally for the whole thing it will create only one object as a reference .
But in Query Statement Each query be an Objects ...
Difference between Active Exe and Dll ?
EXE is ae executable file, while Dll is not. Dll cannot be used independantly.
The Dll is a reusable component which can be referred by a EXE.
Can two web application share a session and application variable ?
No, can't share. Becoz. both web application session's are different and also for application variables.
What is web application virtual directory ?
Web applications and vitual directories to share the inforamation over an internet , an intranet or an extranet.web sites , web applications and virtual directories are work together in a hirarichacal relationship as the basic building blocks for hosting online content.
web sites containes one or more web applications, web application containes on or more virtual directories.and virtual directory map to physical directory of web server.
Difference between application and session ?
session object is used to store information between http request for a particular user. Application are globally across users.
How to find the client browser type ?
Request.UserAgent
Response.Write(Request.Browser.Type);
Request.ServerVariables("http_user_agent")
we can identify the browser name using javascript
var brw = new navigator();
alert(brw.appname);
alert(brw.appversion);