VB Interview Questions - Part I

• 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")?