ASP Interview Questions

By | April 28, 2014

  1. Why do you use Option Explicit?
  2. What are the commonly used data types in VBScript?
  3. What is a session object?
  4. What are the three objects of ADO?
  5. What are the lock-types available in ADO? Explain.
  6. What are the cursor types available in ADO? Explain.
  7. What is a COM component?
  8. How do you register a COM component?
  9. What is a virtual root and how do you create one?
  10. What is a database index, how do you create one, discuss its pros and cons?
  11. How do you use multiple record sets (rs.NextRecordSet)?
  12. As soon as you fetch a record set, what operations would you perform?
  13. Define a transaction. What are ACID properties of a transaction?
  14. How would you remotely administer IIS?
  15. What is RAID? What is it used for?
  16. What is normalization? Explain normalization types.
  17. What is the disadvantage of creating an index in every column of a database table?
  18. What are the uses of source control software?
  19. You have a query that runs slowly, how would you make it better? How would you make it better in .NET environment?
  20. What is a bit datatype? What is it used for?
  21. How would you go about securing IIS and MS-SQL Server?
  22. What is the difference between Request(”field”) and Request.Form(”field”)?

=============================================================================================  

  • What is code in asp for Redirect to another page
  • What is the difference between Server.Transfer and response.redirect ?
  • How many types of cookies are available in asp?
  • Name the ASP Objects?
  • What is the maximum size of an array?
  • Arrays can be resized by using the keyword REDIM
  • <%@ Language=VBScript %> <%If false then> <!– #INCLUDE FILE=”FunctionOne.inc”–> <%Else> <!– #INCLUDE FILE=”FunctionTwo.inc”–> <%End If> What would the above code load?
  • How are sessions maintained?
  • How to Display images using Response object?
  • <SCRIPT LANGUAGE=”VBScript” RUNAT=Server> a = 1 </SCRIPT> <SCRIPT LANGUAGE=”VBScript”> a = 2 </SCRIPT> <% Response.Write a %> In the sample code shown above, what will be written to the screen?
  • <% iPos = Instr(“Hello World”,”r”) %> Referring to the above, what is the value of iPos?
  • What is the Order of precedence for ARITHMETIC Operators. ^, -(negation), *or /, , mod, + or –
  • <% Response.Redirect(“http://www.sql.com”) %> What does the above code accomplish?
  • How to include Active x controls in ASP code
  • 1 What programming model is ASP based on? 2 Advantages of using interfaces for data access? 3 What does connection.execute,connection.open do? 4 set application(”varname”)=session what happens here? 5 How do you define disconnected Recordset in ASP? 6 If ActiveCommand property not set in ASP what happens? 7 Application_start,session_start session_end application_end Is the order important? 8 What is 1 mod 2?
  • I want to generate a report using a date, i give in a text box, then the report is generated on a new page in asp, but if i want to generate it to Excel file, it will not take the date which I have given in the text box, Why ?
  • How do assign the memo data type in ASP page as variable? and I want to place that variable in HTML’s textarea as its value?
  • What are the differences between ASP and ASP.NET and is ASP.NET backward cmpatible to ASP.
  • How to display a word document (.doc) file in html page using ASP?
  • What is http header

 =======================================================================================================

  1. How many objects are there in ASP?
  2. Which DLL file is needed to be registered for ASP?
  3. 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).
  4. What is diffrence between Server.transfer and Response.redirect.
  5. Is there any inbuilt paging(for example shoping cart. which will show next 10 records without refreshing) in ASP? How will you do pating.
  6. What does Server.MapPath do?
  7. Name at least three methods of response object other than Redirect.
  8. Name at least two methods of response object other than Transfer.
  9. Tell few programming diffrence between ADO and DAO programming. What is state?
  10. How many types of cookies are there?
  11. Tell few steps for optimizing (for speed and resources) ASP page/application

==========================================================================================================

  • . which tag i need to use manually to bind columns in a datagrid ?
  • hi this is madhu i have one doubt,regarding siebel Q: is this is mandatory when we r doing join between a bc & table , the table should extension table Reqired or not, can we do the join with base table also,
  • 6) Events in page life cycle?
  • what is mean of ASP?
  • where should i get free version of Test Director to download
  • • How do you relate an aspx page with its code behind page?
  • What is the code for closing the form(using controls) instead of directly closing it?
  • Tell something about Active Server Pages?
  • can we place Global.asa into “bin” directory instead of Root directory?
  • What is Extranet?
  • What is a TextStream object?
  • What is Server Object?
  • How will you delete a Cookie?
  • What are the advantages of Cookies over Session Object?
  • What are the event handlers of Session Object?

 ===========================================================================================================

What is ASP? ASP stands for Active Server Pages. It is a server side technology which is used to display dynamic content on web pages. For example you could write code that would give your visitors different information, different images or even a totally different page depending on what browser version they are using. How can you disable the browser to view the code? Writing codes within the Tag Question What is a “Virtual Directory”? Virtual directories are aliases for directory paths on the server. It allows moving files on the disk between different folders, drives or even servers without changing the structure of web pages. It avoids typing an extremely long URL each time to access an ASP page. Give the comment Tags for the following? VBScript : REM & ‘(apostrophe) JavaScript : // (single line comment) /* */ (Multi-line comments) Which is the default Scripting Language of ASP (server-side)? VBScript Which is the default Data types in VBScript? Variant is the default data type in VBScript, which can store a value of any type. What is a variable? Variable is a memory location through which the actual values are stored/retrieved. Its value can be changed. What is the maximum size of an array? Up to 60 dimensions. What is Querystring collection? This collection stores any values that are provided in the URL. This can be generated by three methods: By clicking on an anchor tag By sending a form to the server by the GET method Through user-typed HTTP address It allows you to extract data sent to the server using a GET request. What are the attributes of the tags? What are their functions? The two attributes are ACTION and METHOD The ACTION gives the name of the ASP file that should be opened next by which this file can access the information given in the form The METHOD determines which of the two ways (POST or GET) the browser can send the information to the server What are the methods in Session Object? The Session Object has only one method, which is Abandon. It destroys all the objects stored in a Session Object and releases the server resources they occupied. What is ServerVariables collection? The ServerVariables collection holds the entire HTTP headers and also additional items of information about the server.What is the difference between Querystring collection and Form collection? The main difference is that the Querystring collection gets appended to a URL. What is a Form collection? The Form collection holds the values of the form elements submitted with the POST method. This is the only way to generate a Form collection. What are the ASP Scripting Objects? The Dictionary object, the FileSystemObject object, TextStream object. What happens to a HTML page? The browser makes a HTTP request; the server gives a HTTP response to the browser and the browser converts into a HTML page. What happens to ASP pages? The browser makes a HTTP request; the server does the processing and gives a HTML response to the browser. How can you change the primary scripting language for a page? Specify What is application Object? Shares information among users of an application. Gives a notification when an application starts or ends. What is the difference between client-side script and server-side script? Scripts executed only by the browser without contacting the server is called client-side script. It is browser dependent. The scripting code is visible to the user and hence not secure. Scripts executed by the web server and processed by the server is called server-side script. What is the command to display characters to the HTML page? Response.Write 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. How many global.asa files can an Application have? Only one global.asa file and it’s placed in the virtual directory’s root. How many global.asa files can an Application have? Only one global.asa file and it’s placed in the virtual directory’s root. What are Scripting Objects? Objects that can enhance the application are known as the Scripting Objects.

What is the Order of precedence for LOGICAL Operators. NOT, AND, OR, XOR, EQV, IMP What is an Err Object? Name it’s properties and methods. What are LOCAL and GLOBAL variables? Local variables lifetime ends when the Procedure ends. Global variables lifetime begins at the start of the script and ends at the end of the script and it can be used by any procedure within the script. Declaring a variable by using the keyword PRIVATE makes the variable global within the script, but if declared using PUBLIC, then all scripts can refer the variable. Which is the default Scripting Language on the client side? JavaScriptWhat is HTML(Hypertext Markup Language)? It’s a method by which web pages can be built and generally used for formatting and linking text. What is a Web Server? It’s a Computer that provides Web services on the Internet or on a local Intranet. It is designed to locate, address and send out simple HTML pages to all other users who access these pages. What is Session Object? It stores information about a User’s session. Gives a notification when a user session begins or ends. What is Server-Side includes? It provides extra information by which it makes the site easier to manage. It can include text files using the #include statement, retrieve the size and last modification date of a file, defines how variables and error messages are displayed and inserts the values of HTTP variables in the page sent back to the browser. What is a FileSystemObject object? It provides access to the physical file system of the web server. It gets and manipulates information about all drives in a server, folders and sub-folders on a drive and files inside a folder. What is a Scripting Language? It permits to create more interactive Web Pages. Validation, formatting of web pages can be done. VBScript, JavaScript are some examples. What is a Dictionary object? It lets you store and retrieve information in a flexible data structure. Each value or information stored in a Dictionary is associated with a key through which the information can be retrieved. What is Global.asa file? It is text file that contains details about an ASP application, such as when it should begin and end. What is an .ASP file? It is a Text File that contains the combination of the following: Text HTML tags Script Commands What is Response Object? It controls the information sent to the user. The various methods are: Response.Write – Sends information directly to a browser Response.Redirect – Directs a user to a URL other than the requested URL Response.ContentType – Controls the type of content sent Response.Cookies – Sets cookie values Response.Buffer – To Buffer information Naming constraints for a variable ? It can be up to 255 characters Must start with an alphabet Must not contain an embedded period or full-stop What is a TextStream object? It allows you to access(read/write) the contents of text files stored on the web server. What is IIS? IIS is a Web Server that provides Web services, not only for web pages but also for ftp sites and video and audio services. It integrates with the database facilities of SQL Server. What is Request Object? Gets information from the user. It has five collections by which values can be accessed. They are: Querystring, Form, Cookies, Server Variables & ClientCertificate What are the special sub-types in VBScript? EMPTY: has no value NULL: Value does not exist (conjunction with database) OBJECT: What is Cookies collection? Cookies are text files that store information about the user by which the web server identifies and marks each different visitor to a web site and determines where a user has been before. A cookie can store information only when the user sends it. Individual cookies are limited to 4KB of data. The maximum number of cookies allowed is 300. Cookies are stored on client’s machine. What is the difference between Cookies collection and Form/Querystring collection? Cookie collection does not have the Count property. Cookies can have multiple values for the same cookie name but each value can be referred using a key whereas in a Form/Querystring cookie each value has to be referred using an index value. What is Server Object? Controls the ASP execution environment. It can set the amount of time script can run before an error occurs. Converts a virtual path to a physical path on the server. Takes a user supplied string and encode it into proper format for a URL string. What is Collection? Collection is a set of name/value pairs where the information supplied by the client is stored. How will you delete a Cookie? By setting its Expires property to any date prior to today Response.Cookies(“cookie name”). Expires = Date 1.

What is the function of Buffer in Response Object? Buffer controls the HTML output stream manually. How are scripts executed? ASP provides scripting engines that execute the corresponding scripting languages on the server side. Scripts should be encoded within the Delimiters. What is ASP (Active Server Pages)? ASP is a server side-scripting environment for building dynamic and interactive web pages. Since the scripts run on the server side, the web server does all the processing. What are ARRAYS? Arrays are variables that store items of similar information.DIM ARRAY1(4) (declares an array with the name array1 with 5 elements) What is Application-scope? Application-scope means that variables (and objects) can be accessed from any ASP pages that is part of the application. What is Extranet? An area of a web site available only to a set of registered visitors. What is a session? A user accessing an application is known as a session. What is ClientCertificate collection? A ClientCertificate is an encrypted number that is stored in a file on the user’s computer. This stores details of any security certificates included with the request. What do you need to run ASP? A browser and a Web server What is the order of execution for an ASP application? 1) Global.asa 2) Server-side Includes 3) Jscript scripts tagged within What are the types of HTML? Static HTML Browser uses HTTP to request HTML file from the Web Server Dynamic HTML Browser uses HTTP to request an executable application rather than a Static HTML file What are the properties of Session Object? SessionID returns the session identification number for each user. Timeout sets the timeout period assigned to the Session object for any application, in minutes. CodePage determines the code page that will be used to display content. LCID a locale identifier, which determines time zone and language, rules for the system What are the event handlers of Session Object? Session _OnStart This event will be fired when a new user begins a session with the web site. Session_OnEnd This event is called whenever a session terminates. Name the ASP Objects? Request Object Response Object Server Object Session Object Application Object What are the advantages of using ASP? Minimizes network traffic by limiting the need for the browser and server to talk to each other Makes for quicker loading time since HTML pages are only downloaded Allows to run programs in languages that are not supported by the browser Can provide the client with data that does not reside on the client’s machine Provides improved security measures since the script cannot be viewed by the browser What are the methods in Application Object? Lock prevents clients from modifying the variables stored in the Application object. Unlock removes the lock from variables stored in the Application object. What are the methods in Application Object? Internet Information Server (IIS) on Windows NT Personal Web Server (PWS) on Windows 95 Peer Web Services on Windows NT What are the browsers that can access ASP pages? Internet Explorer (supports VBScript, JavaScript) Netscape Communicator/ Navigator (supports only JavaScript, VBScript can be also added too) What are the methods by which output stream is controlled? Flush sends previous buffered output to the client immediately, but continues processing the script. Clear erases any already-buffered HTML. End causes the server to stop processing the script. What are the methods by which output stream is controlled? What are the properties used to control the expiration of the page? Expires specifies the number of minutes before a page cached on a browser expires. ExpiresAbsolute sets the date and time at which a page cached on a browser expires.

What are the collections of Session Object? Contents collection contains all the variables established for a session without using the tag. Static collection contains all the objects created What is the difference between ASP and HTML? Or Why ASP is better than HTML? – ASP executes code on the server side whereas the browser interprets HTML. – ASP can use any scripting languages – Gets feedback from the user and return information to the user – Create pages that will be customized to display only things that will be of interest to a particular user – Can edit contents of a web page by updating a text file or a database rather than the HTML code itself What are the event handlers of Application Object? Application_OnStart- This event will be fired when the first visitor hits the page. Application_OnEnd- This event runs when the server is stopped. Name some of the ASP components? Ad Rotator component- a way to manage advertisements on the web site. Content Linker component – a technique to direct users through a set of pages on a web site by creating a list of URLs and description of the next and previous pages. Browser Capabilities component – allows to customize the page to the ability of the browser viewing it. Database Access component – allows to access data from the database What are the tasks performed by <> tags? tags provides space for the user to input values the form has a button to submit information back to the server It transfers control to another ASP page It carries the information in the fields to another ASP page What are the tags necessary to be present within the tag ? —–tag: Provides input spaces (text boxes, combo boxes, radio button, etc.) on a form called fields. It has three attributes TYPE, NAME and VALUE. TYPE provides the characteristics of the field and the NAME specifies a name to the field by which it can be referred. What are the collections of Application Object? * Contents collection – contains all variables added via scripts in global.asa. * Static collection – contains the names of all objects How do you create a recordset object in VBScript? Answer1 //First of all declare a variable to hold the Recordset object, ex- Dim objRs //Now, Create this varible as a Recordset object, ex- Set objRs=Server.CreateObject(ADODB.RECORDSET) Answer2 ” rs.MoveNext wend end if %’> *. Create Recordset object *. Place form field value in a variable named “param” *. Define query by concatenating strings and variable value *. Open RecordSet Object. Note that the first parameter is the Command Text. The second parameter is the Connection String. The Command Object and Connection Object are created implicitly. *. Make sure the RecordSet isn’t empty *. Begin executing a loop which goes through all records in the RecordSet. *. Write each record’s “firstname” and “lastname” fields to the page on a separate line. *. Move to Next Record. Explain the difference between POST and GET Method. GET requests are string data that is visible to the end user via the URL and a limit of 2kb, POST requests have no limit on total data and the user can’t see the data in a query string. Why do we use Option Explicit? Answer1 To avoid multiple variables of the same name. Answer2: Correct answer is – This statement force the declaration of variables in VB before using them. How do you write an SQL insert statement? insert into tablename (fieldA, fieldB, fieldC)Values(’dataA’, ‘dataB’, ‘dataC’); How can you have different number of cells for each row of a table in HTML? using colspan and rowspan What variable can you use to share info across the whole application for one user? Use the sessions object What is string concatenation function in VBScript? the ampersand symbol and ampersand space underscore across multiple lines How do you get the value of a combo box in Javascript? Answer1. document.forms[’formName’].elements[’comboName’].options[i].value Answer2. document.form_name.element_name.value What is a class in CSS? Answer1 A class allows you to define different style characteristics to the same HTML element. Answer2 class is a child to the id, id should be used only once, a css class can be used multiple times: div id=”banner” p class=”alert” When inserting strings into a SQL table in ASP what is the risk and how can you prevent it? SQL Injection, to prevent you probably need to use Stored Procedures instead of inline/incode SQL Which is the default Data types in VBScript? Variant.

=========================================================================================================

  1. What is Extranet?

  • What is an Err Object?
  • What is a TextStream object?
  • What is Server Object?
  • How will you delete a Cookie?
  • What are the advantages of Cookies over Session Object?
  • What are the event handlers of Session Object?
  • What is ClientCertificate collection?
  • What is ServerVariables collection?
  • What is the difference between Cookies collection and Form/Querystring collection?
  • What is Cookies collection?
  • What is the difference between Querystring collection and Form collection?
  • What is a Form collection?
  • What is Querystring collection?
  • What are the attributes of the tags? What are their functions?
  • What are the tasks performed by tags?
  • What is the order of execution for an ASP application?
  • How can you change the primary scripting language for a page?
  • How does the server identify and execute the server-side scripts within HTML code?
  • How can you disable the browser to view the code?
  • Give the comment Tags for the following:
  • What is the difference between client-side script and server-side script?
  • What is a “Virtual Directory”?
  • What are the browsers that can access ASP pages?
  • How are scripts executed?
  • What is an .ASP file?
  • Using VBScript, which of the following Scripting Object(s) is NOT available from scrrun.dll?
  • Which choice is NOT a property of Dictionary Object?
  • What is the use of following Statement Response.Expires=120
  • How to Display images using Response object?
  • What purpose is served by the Application.Lock method?
  • The FileSystemObject provides an object interface to drives, directories, and files for which of the following?
  • Which-code sample will report whether the client’s browser supports cookies?
  • How long is a SessionID guaranteed to be unique?
  • When does the application OnEnd event handler fire?
  • How are sessions maintained?
  • What does the above code accomplish?
  • Referring to the above, if you want to pass the contents of the strName variable in a hyperlink, which line of code would you use?
  • What are the collections of Application Object?
  • How many global.asa files can an Application have?
  • What is Application-scope?
  • What is application Object?
  • What is Collec

 

Leave a Reply