Realtime .NET, SQL, Architecture Interview Questions 1

.net
====
1. what is the diff bet arraylist and hashtable
2. Can objects be stored in arraylist
3. Can arraylist be used instead of generics
4. Differenece between hashtable and dictionary

SQL
===
1. what is indexview

2. what are the 3 types of udfs

3. how will you find which join is running slowly

5. how will you handle exceptions in sql
6. how will you show your exceptions to the user


Architecture
============
1. can proxy pattern be used instead of observer pattern
2. can u say an alternate for observer pattern

www.codecollege.NET

What are the different types of UDFs ?

There are 3 types of UDFs, they are:
1. Inline.
2. Scalar valued.
3. Multistatement returning.

www.codecollege.NET

What are the Differeneces between Hashtable and Dictionary ?

Dictionary is faster than hashtable as it uses strongly typed values as input , so it will not suffer performance impact of doing the boxing \ unboxing.

www.codecollege.NET

Can objects be stored in arraylist ?

Yes.

www.codecollege.NET

What is the diff bet arraylist and hashtable ?

Hashtable has key to search and arraylist is not having, so hashtable is faster than arraylist.

www.codecollege.NET