Accenture, Bangalore

Telephonic on Oct 28, 2010

1. What are the various types of joins?

2. What are the differences between Having and Where?

3. What are the difference between Delete and Drop?

4. What are the difference between Delete and Truncate?

5. What are the various types of triggers?

6. What are the differences between SP and Functions?

7. What is the difference primary key and foreign key?

8. How many clustered indexes you can create on a table?

9. Is it possible to RollBack without transactions?

10. What is a delegate?

Empress Technologies, Ernakulam

Telephonic on Oct 28, 2010

1. What is MVC framework?
2. What is the difference between HashTable and Dictionary?
3. What is the difference between Array and ArrayList?
4. What is T4?
5. What is DSL?
6. What is MVC and what is MVVM?
7. Did you implement Ajax? How did you do?
8. What is groupby?

9. What are the things you have to consider to create a table
10. Order table has Customer, OrderNo, Description, Date and Amount. Write a query to find out the customer who purchased more than 100 times in last month.
11. What is the ViewState and what are the advantages and disadvantages of it?
12. A dropdown list has 1000 records. How will you keep the records during postbacks? Will you connect with DB and load the drop down list every postback or store the records in ViewState?
13. What will you do if you want to show huge records in a GridView?

14. How can you call a server side function by javascript?

Encora Technologies, Bangalore.

Telephonic on Oct 27, 2010

1. Is it possible to override Finalize?
2. What are the basic steps you have to follow to implement IDisposable?
3. What is the difference between List and ArrayList?
4. What are the data types you can store in an ArrayList?
5. What is the difference between HashTable and Dictionary?
6. How many generations are there in GC?
7. What are data types you can use as a key in dictionary?
8. If finally throws exception, who will handle it or How will you handle it?
9. How will you debug a SP? Is it possible to set a breakpoint?
10. What will be the ConnectionString, if the DB server is in another machine? Just SQL Server name is enough?
11. Is connection procedure same for SQL Server and oracle in ADO.NET?
12. string s1 ="India"; string s2 = "India";
What is the output of s1 == s2 and output of s1.Equals(s2)?
13. string str ="Any combination of alphanumeric and special characters"
How will you find the occurrences of each character?

Congruent Solutions, Chennai

F2F on 2009

1. What is stack and heap?

2. Why C# codes are converted to IL and why C++ codes are converted to machine code not IL?

3. struct A

{

int a;

}

A.a.ToString();

What is the output?

4. How does the following code work? DataReader dr; for(DataRow r in dr) {}

5. What are delegates? How will you add more than one method to a delegate?

6. Does the following code work?

class A {}

class B : A {}

A a1 = new B();

7. Two classes: a, b

________ fun()

{

int I = 10;

if(I == 10) return new a();

else return new b();

}

What will be the return parameter?

8. interface A { int print(); }

interface B { int print(); }

class C : A, B

{

int print() { Print “Welcome”; }

}

How will you call B’s print method?

9. What is HTTPHandler?

10. What is the purpose of HTTP, SOAP in webservice.

11. How many master pages does a page contain?

12. Is it possible to have nested master pages?

13. What is difference between XAML and XML

14. How will you pass a table returned by a SP as parameter to another SP.

15. Where is the table name stored in SQL Server?

16. Write a query to get all the table names.

17. Consider a subquery is used in more than one query in a SP. How will you achieve this? That is how will you write a query that reuses a subquery?

18. Table A has 5 rows and table B has 7 rows. How many rows does “Select * from A, B” return?

Logica, Chennai

1st Round, F2F on Oct 23, 2010

To check communication skill, HR has discussed with me for 3 - 5 mins about my family, studies and experience.

2nd Round, F2F on the same day

1. What is a chain constructor?

2. Is this the proper way? If yes why, if no why?

try { }

catch(Exception ex) { }

catch(ArgumentNullException) { }

catch(ArgumentNullException) {}

catch {}

finally {}

3. What is lambda expression?

4. What is anonymous type?

5. What is the difference between interface and abstract?

6. What is data modeling?

7. Difference between MVVM and MVC?

8. How will implement gate pass entry application using MVVM

9. What is UML?

10. What is design pattern?

11. What is singleton, how will you implement?

12. What is the max size of Viewstate?

13. Difference between session and viewstate?

14. What is agile methodology? What are the advantages?

15. You have edited some value in a gridview. How will you update those values to dataset?

16. Difference between Acceptchanges and Updatechanges in dataset?

17. Difference between WCF and web services

18. Why do we go for web services?

19. Difference between .NET Remoting and web services

20. What is Pivot?

21. Employee table has two columns - eId, eName;

What is the output of the following queries?

Select eId eName as Name from Employee

Select eId eName from Employee

SRA Systems, Chennai

2nd Round, F2F on Oct 22, 2010

1. What is .NET framework?
2. What is a master page?
3. A page has two custom controls. How will you update one custom control by another one without refreshing the page?
4. What is a session?
5. What is a viewstate?
6. Which encryption method is followed for viewstate?
7. Is it possible to encrypt a viewstate value by code?
8. What are magic tables?
9. What is table variable?
10. Explain MVVM
11. How will you configure windows authentication in IIS?
12. What is a delegate?
13. What are custom events?
14. What is an assembly and What are its types?
15. Is it possible to convert private assembly to public? How?
16. What is strong name?
17. What is temp and temp database?
18. Is it possible to separate the settings, save in different files and access in the web.config file
19. What is Global.asax? Is it mandatory?
20. What is web.config?
21. What are the .NET 4.0 features you used in your project?

22. What is Generics?

23. What is MSIL?

Value Source Technologies, Chennai

F2F on Oct 21, 2010

1. What is a Partial class?

2. Are keys in a dictionary unique?

3. In a hashtable, what are data types you can use as a key?

4. Program to reverse a string and check whether it is a palindrome without using built in functions

5. What is a Disposable Pattern?

6. What is String Builder?

7. Is Reflection used only to get the metadata of an assembly?

8. What is dll hell?

9. Difference between Stored Procedure and Function?

10. What is a Constructor?

11. What is Method overloading and Method overriding?

12. Is it possible to override a function in the child class without any virtual function in the base 
13. How will you implement Google's suggestions while searching something

14. WPF Architecture, TwoBinding, PresentationCore, Resources

15. Twoway binding between a property and a TextBox, Either on button click or via a short cut key (alt or ctrl + some key) it will show the Text in the TextBox. I entered a Text and pressed the short cut key. What will happen? Error or Entered Text or ?

16. Register tag in ASP.NET then why add reference, How to use custom control and user control in ASP.NET Page

17. Difference between themes and skins

18. Difference between style sheets and skins

19. A string has "Hello , Good Morning", print with the name given by user

20. void Q(int i)

{

Q(i/2);

Console.Writeline(i);

}

What is the output?

21. Difference between interface and abstract.

22. Two functions:

int Add(int A, int B) { // Your code }

int Add(int A, int B, int C) { return (A + B + C); }

You should call the second method in first to perform addition of A and B. How will you do?

SRA Systems, Chennai

1st Round, Written on Oct 20, 2010

1. What is the purpose of STA Thread?

2. Which one do you use to get 10 records from a web service – DataSet or DataReader

3. How will you enable caching in a web service?

4. Is JIT in CLR?

5. Connection pooling

6. Parallel tasking

7. How will you enable session in a web service?

Symphony, Bangalore

Telephonic on Oct 15, 2010

1. What are Routed Events and give an example for tunneling event.

2. Difference between Stack and Heap.

3. Find 5th element from the end in a LinkedList

4. Difference between Finalize and Dispose

5. Difference between dependency and CLR property

6. What is bindings and what is multibinding?

7. What is GAC?

8. What is Observable collection?

9. What is INotifyPropertyChanged?

Cumulux, Chennai

F2F on Oct 12, 2010

1. What is Singleton pattern? In which scenario you will use it?

2. What are joins? Give an example for Self-join.

3. Is it possible to create nested DataReaders

4. What are the advantages of MVVM?

5. What are the advantages of Twoway binding?