KAVISHREE

We are Adding all type of Important FAQ relating to IT people For the Interview

1.Why do you use Option Explicit.

Ans:

Using Option Explicit requires that all variables be declared before being used. (It is considered to be good programming practice)

2.What are the data types in VBScript.

Ans:

VBScript consists of only one data type (Variant)

3.What is a session Object.

Ans:

A Session Object holds information relevant to a particular users session.

4.What are the three Objects of ADO.

Ans:

Connection, Command, Recordset (There are actually more than 3 (Primary objects are (Connection, Command, Field and Recordset) Secondary objects are (Parameters, Properties and Errors)))

5.What are the lock-types available in ADO.Explain.

adLockReadOnly (1) - Indicates read-only records. You cannot alter the data.

adLockPessimistic (2) - Indicates pessimistic locking, record by record. The provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately after editing.

adLockOptimistic (3) - Indicates optimistic locking, record by record. The provider uses optimistic locking, locking records only when you call the Update method.

adLockBatchOptimistic (4) - Indicates optimistic batch updates. Required for batch update mode.

adLockUnspecified (-1) - Does not specify a type of lock. For clones, the clone is created with the same lock type as the original

6.What are the cursor types available in ADO.Explain.

adOpenForwardOnly (0) - Default. Uses a forward-only cursor. Identical to a static cursor, except that you can only scroll forward through records. This improves performance when you need to make only one pass through a Recordset.

adOpenKeyset (1) - Uses a keyset cursor. Like a dynamic cursor, except that you can�t see records that other users add, although records that other users delete are inaccessible from your Recordset. Data changes by other users are still visible.

adOpenDynamic (2) - Uses a dynamic cursor. Additions, changes, and deletions by other users are visible, and all types of movement through the Recordset are allowed, except for bookmarks, if the provider doesn�t support them.

adOpenStatic (3) - Uses a static cursor. A static copy of a set of records that you can use to find data or generate reports. Additions, changes, or deletions by other users are not visible.

adOpenUnspecified (-1) - Does not specify the type of cursor.

7.How do you register a COM component.

Regsvr32 �C:\COMObjects\Help.dll�

To unregister

Regsvr32 �C:\COMObjects\Help.dll� -u

9.What is a virtual root and how do you create one?.

Better known as Virtual Directory. Allows you to create multiple website under 1 ip address. Allows you reference another location (folder) to include additional functionality.

To create one

1) Open IIS Manager

2) Right click the default site and �New�>�Virtual Directory�.

3) Type the name of the virtual directory and then browse to the location you would like to reference.

10.What is a database index, how do you create one, discuss it�s pros and cons.

Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quicker. Indexes are of two types. Clustered indexes and non-clustered indexes. When you create a clustered index on a table, all the rows in the table are stored in the order of the clustered index key. So, there can be only one clustered index per table. Non-clustered indexes have their own storage separate from the table data storage. Non-clustered indexes are stored as B-tree structures (so do clustered indexes), with the leaf level nodes having the index key and it�s row locater. The row located could be the RID or the Clustered index key, depending up on the absence or presence of clustered index on the table. If you create an index on each column of a table, it improves the query performance, as the query optimizer can choose from all the existing indexes to come up with an efficient execution plan. At the same t ime, data modification operations (such as INSERT, UPDATE, DELETE) will become slow, as every time data changes in the table, all the indexes need to be updated. Another disadvantage is that, indexes need disk space, the more indexes you have, more disk space is used.

11.What is the default language of ASP.

VBScript

12.How do you use multiple record sets( rs.NextRecordSet ).

Using rs.NextRecordset (http://www.15seconds.com/howto/pg000089.htm)

13.As soon as you fetch a record set, what operations would you perform.

Check to make sure records were returned�if so, then manipulate them.

14.Define a transaction. What are acid properties of a transaction.

A transaction is a process where either something completes or it fails depending on its requirements

ACID properties of a transaction

A - Atomicity = The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.

C - Consistency = The transaction takes the resources from one consistent state to another.

I - Isolation = A transaction�s effect is not visible to other transactions until the transaction is committed.

D - Durability = Changes made by the committed transaction are permanent and must survive system failure.