ASP, ADO Interview Questions

  • How many objects are there in ASP?
  • Which DLL file is needed to be registered for ASP?
  • If you want to initialize a global variable for an application, which is the right place to declare it? (like form or some other file).
  • What is diffrence between Server.transfer and Response.redirect.
  • Is there any inbuilt paging(for example shoping cart. which will show next 10 records without refreshing) in ASP? How will you do pating.
  • What does Server.MapPath do?
  • Name at least three methods of response object other than Redirect.
  • Name at least two methods of response object other than Transfer.
  • Tell few programming diffrence between ADO and DAO programming. What is state?
  • How many types of cookies are there?
  • Tell few steps for optimizing (for speed and resources) ASP page/application
  • Why do you use Option Explicit?
  • What are the commonly used data types in VBScript?
  • What is a session object?
  • What are the three objects of ADO?
  • What are the lock-types available in ADO? Explain.
  • What are the cursor types available in ADO? Explain.
  • What is a COM component?
  • How do you register a COM component?
  • What is a virtual root and how do you create one?
  • What is a database index, how do you create one, discuss its pros and cons?
  • How do you use multiple record sets (rs.NextRecordSet)?
  • As soon as you fetch a record set, what operations would you perform?
  • Define a transaction. What are ACID properties of a transaction?
  • How would you remotely administer IIS?
  • What is RAID? What is it used for?
  • What is normalization? Explain normalization types.
  • What is the disadvantage of creating an index in every column of a database table?
  • What are the uses of source control software?
  • You have a query that runs slowly, how would you make it better? How would you make it better in .NET environment?
  • What is a bit datatype? What is it used for?
  • How would you go about securing IIS and MS-SQL Server?
  • What is the difference between Request(”field”) and Request.Form(”field”)?



Labels: ,

10 comments:

  1. AnonymousWed Dec 13, 02:49:00 AM 2006

    Great work. Post answers for these questions also. Thank you.

    ReplyDelete
  2. SvkSat Mar 22, 01:36:00 AM 2008

    How many types of cookies are there?

    2 types

    persistent and unpersistent

    ReplyDelete
  3. AnonymousSat Mar 22, 01:53:00 AM 2008

    What does Server.MapPath do?

    Syntax is Server.MapPath(path)

    where path is the parameter Required. A relative or virtual path to map to a physical path. If this parameter starts with / or \, it returns a path as if this parameter is a full virtual path. If this parameter doesn't start with / or \, it returns a path relative to the directory of the .asp file being processed.

    ReplyDelete
  4. AnonymousSat Mar 22, 02:06:00 AM 2008

    Name at least two methods of response object other than Transfer?

    response.write

    response.redirect

    response.transfer

    response.execute

    ReplyDelete
  5. AnonymousSat Mar 22, 02:10:00 AM 2008

    The Session object is used to store information about, or change settings for a user session. Variables stored in the Session object hold information about one single user, and are available to all pages in one application.

    ReplyDelete
  6. AnonymousSat Mar 22, 02:19:00 AM 2008

    Answ: Q1

    There are 6 objects. 1. Request, 2.Response, 3. Session, 4. Server, 5. Application, 6. ObjectContext

    ReplyDelete
  7. AnonymousSat Mar 22, 02:23:00 AM 2008

    What is diffrence between Server.transfer and Response.redirect?

    The Redirect method causes the browser to redirect the client to a different URL.
    Syntax : Response.Redirect(URL)

    The Transfer method sends all of the information that has been assembled for processing by one .asp file to a second .asp file.
    Syntax : Server.Transfer(PATH)

    ReplyDelete
  8. AnonymousSat Mar 22, 02:27:00 AM 2008

    there is no response.execute

    method...

    ReplyDelete
  9. AnonymousSat Mar 22, 02:42:00 AM 2008

    Explain the POST & GET Method or Explain the difference between them.

    POST METHOD:
    The POST method generates a FORM collection, which is sent as a HTTP request body. All the values typed in the form will be stored in the FORM collection.
    GET METHOD:
    The GET method sends information by appending it to the URL (with a question mark) and stored as A Querystring collection. The Querystring collection is passed to the server as name/value pair.
    The length of the URL should be less than 255 characters.

    ReplyDelete
  10. AnonymousThu Nov 11, 12:56:00 AM 2010

    Hi

    I read this post 2 times. It is very useful.

    Pls try to keep posting.

    Let me show other source that may be good for community.

    Source: Good interview questions

    Best regards
    Jonathan.

    ReplyDelete

Subscribe to: Post Comments (Atom)