Asp Interview Questions and Answers Part 4

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.