Microsoft platform and database technologies interview questions

1. 3 main differences between flexgrid control and dbgrid control
2. ActiveX and Types of ActiveX Components in VB
3. Advantage of ActiveX Dll over Active Exe
4. Advantages of disconnected recordsets
5. Benefit of wrapping database calls into MTS transactions
6. Benefits of using MTS
7. Can database schema be changed with DAO, RDO or ADO?
8. Can you create a tabletype of recordset in Jet - connected ODBC database engine?
9. Constructors and destructors
10. Controls which do not have events
11.Default property of datacontrol
12.Define the scope of Public, Private, Friend procedures?
13. Describe Database Connection pooling relative to MTS
14. Describe: In of Process vs. Out of Process component. Which is faster?
15. Difference between a function and a subroutine, Dynaset and
16. Snapshot,early and late binding, image and picture controls,Linked Object and Embedded
17. Object,listbox and combo box,Listindex and Tab index,modal and moduless window, Object and Class,Query unload and unload in form.
18. Declaration and Instantiation an object?
19. Draw and explain Sequence Modal of DAO
20.How can objects on different threads communicate with one another?
21.How can you force new objects to be created on new threads?
22. How does a DCOM component know where to instantiate itself?
23.How to register a component?
24. How to set a shortcut key for label?
25. Kind of components can be used as DCOM servers
26. Name of the control used to call a windows application
27. Name the four different cursor and locking types in ADO and describe them briefly.
28. Need of zorder method, no of controls in form, Property used to add a menus at runtime,
29. Property used to count number of items in a combobox,resize a label control according to your caption.
30. Return value of callback function, The need of tabindex property.
31.Thread pool and management of threads within a thread pool.
32.To set the command button for ESC, Which property needs to be changed?
33.Type Library and what is it’s purpose?
34. Types of system controls, container objects, combo box
35.Under the ADO Command Object, what collection is responsible for input to stored procedures?
36.VB and Object Oriented Programming
What are the ADO objects? Explain them.

ASP, ADO and IIS interview questions

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”)?