General IIS related questions

What is normalization
-    What is an index and types of indexes. How many number of indexes can be used per table
-    What is a constraint. Types of constraints
-    What are code pages
-    What is referential integrity
-    What is a trigger
-    What are different types of joins
-    What is a self join
-    Authentication mechanisms in Sql Server
-    What are user defined stored procedures.
-    What is INSTEAD OF trigger

1. What is the data type of the surrogate key?
2. What are the steps to build the data warehouse?
3. What are the different architectures of data warehouse?
4. What are the advantages data mining over traditional approaches?
5. What is the difference between view and materialized view?
6. What is the main difference between Inmon and Kimball philosophies of data warehousing?
7. What is junk dimension? what is the difference between junk dimension and degenerated dimension?

1. Explain the .NET architecture.
2. How many languages .NET is supporting now? - When .NET was introduced it came with several languages. VB.NET, C#, COBOL and Perl, etc. The site DotNetLanguages.Net says 44 languages are supported.

What are different transaction options available for services components ?
There are 5 transactions types that can be used with COM+. Whenever an object is registered with COM+ it has to abide either to these 5 transaction types.

Disabled: - There is no transaction. COM+ does not provide transaction support for this component.

1. What are the new Data Controls in Asp.net 2.0?Data access in ASP.NET 2.0 can be accomplished completely declaratively (no code) using the new data-bound and data source controls. There are new data source controls to represent different data backends such as SQL database, business objects, and XML, and there are new data-bound controls for rendering common UI for data, such as gridview, detailsview, and formview.

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?

What distributed process frameworks outside .NET do you know?
Distributed Computing Environment/Remote Procedure Calls (DEC/RPC), Microsoft Distributed Component Object  (DCOM), Common Object Request Broker Architecture (CORBA), and Java Remote Method Invocation (RMI).
What are possible implementations of distributed applications in .NET?