Dell Dotnet and Database Interview Questions

Dell Dot net and Database Interview Questions
DOTNET
* Any disadvantages in Dataset and in reflection
* Difference between Active Exe and Activex dll
* Can we make activex dll also ti execute in some process as that of client ? How can we do?
* Types of compatabilities and explain them
* Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default
* What is assembly?
* Difference between COM and .NET component
* What is early binding and Late binding. Difference which is better
* What happens when we instantiate a COM component
* What happens when we instantiate a .NET component
* Are you aware of containment and Aggregation
* What is UUID and GUID what is the size of this ID?
* About Iunknown interface Queue ,its methods Querry Interface Addref,Release and Explane each
* What ‘ll u do in early and late binding
* In early binding will the method invoked on com component will verify it’s existance in the system or not?
* Difference between dynamic query and static query
* About performance issues on retrieving records
* About ADO and its objects
* What is unmannaged code and will CLR handle this kind of code or not .
* Garbage collector’s functionality on unmanaged code
* If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?
* Threading Types.
* How about the security in Activex DLL and Activex EXE
Database
* Types of cursors and explanation each of them
* Types of cursor locations and explanation on each of them
* Types of cursor locks and explanation each of them
* How do you retrieve set of records from database server.{Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }