ASP Interview Questions and Answers

1.Why do you use Option Explicit.
2.What are the 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 it's pros and cons.
11.What is the default language of ASP.
12.How do you use multiple record sets( rs.NextRecordSet ).
13.As soon as you fetch a record set, what operations would
you perform.
14.Define a transaction. What are acid properties of a
transaction.
15.How would you remotely administer IIS.
16.What is RAID? What is it used for.
17.What is normalization?. Explain normalization types.
18.What is the disadvantage of creating an index in every column
of a database table.
19.What are the uses of source control software.
20.You have a query that runs slowly, how would you make it better.
21.What is a bit datatype?.What is it used for.
22.How would you go about securing IIS and MS-SQL Server.
23.What is the difference between Request("field) and Request.Form("field").
24.Few example scenarios of static and dynamic XMLs.