Deloitte Dotnet Interview Questions

Hi friends one of my friend Aryan  shared  below Dotnet interview question which he recently faced at Deloitte, Mumbai for 3 years of experience.


A. Scenario

• We have one application which is hosted on 4 different server if suppose the one web server is down that time what will going to be happen for the user who is going to do transaction on that particular web server.Answer related to NBL and webfarms.
• On IIS 7.5 , two web application hosted and both using the same application pool if suppose the one web app down for maintenance can it ll affect the another web application.

B.  General Programming

1. Difference between HTML Control and Server Control
2. Can you write down the Stack program in CSharp
3. Can you write down the binary search algorithm
4. Suppose int a=10; string b="xyz"; a=b will it compile the answer is no then the nxt q int a=10; string b="150"; a=Convert.toInt32(b); response.write(a); will it compile and if compile then what is output
5. What is meaning of assembly
6. how to make the assembly public write the strongly type commands
7. if suppose i have class called testclass, e.g private class TestClass{} i compiled and make the dll of that particular calss and placed it in GAC folder so it will become public assembly can i used in my any other project but the class is private
8. Difference between hashtable and arraylist
9. What are Generics ? 

C.  SQL

1. What is equijoin
2. In SSRS, explain the grouping concept
3. Suppose i have one table called Test1 having 2 rows and 2 coloumn

Test1

ID   Name

1     A

2     B

Test2

ID   Salary

1    10

2    20

3    30 

4    40

Select 

            b.name, a.salary

 From 

         Test2  as a

          right join 

          Test1 as b

   on

          a.id=b.id       

              OP???

4. Write the syntax of trigger?
5. Level of Nested Trigger?

For More Asp.net MVC InterviewQuestions  
TCS Asp.net MVC Interview Questions
Capgemini Asp.net MVC Interview Questions

Hi friends if any of you attended interviews recently ,please send your interview experiences  to my mail id  : nsubhash007@gmail.com

 

L&T Info tech Dotnet interview questions

LnT InfoTech Mumbai

First round Technical interview questions

1,.  C# 3.5 features

2. Use of delegates?

3. State management concepts in asp.net?

4. Difference control state and view state?

5. Page life cycle events, in which state post back event handling will occur?

6.  In which event you can change the content of the page?

7. What is GAC?

8. What is CTS?

9. I have two assemblies with same name but different versions, how i can choose the assemblies based on versions?

10. What is difference between stored procedure and function?

11. Can function return @table valued parameter?

12. Difference between temp table and global temp table and @table valued parameter?

13. Types of logs in sql server?

14. Use of Instead of trigger?

15. Nested transactions in sqlserver?

16. How do you call the garbage collector explicitly?

-------------------------------------------------------------------------------------

Second round Technical interview

Asp.net

1. Tell me the steps to deploy the WCF service on IIS server?

2. Use of HTTP of modules in asp.net?

3   what is asp.net pipe line?

4. What is application pool, and its responsibilities?

C#

5. What happen exactly when you compiling and executing the code in VS internally?

6 what is csc.exe and what it does?

7. What is the meaning for mutable and immutable?

Webform1 textbox label

8.  I have a webform1 and one user control which contains a button control, when I click on the button text entered in the text box should display in the label? Tell me in step wise

                 

button

Side questions:

How to call the user controls, difference between user controls and custom controls

9.    I have a class A, B, and C

Public class A {}

Public  class B                                                     public   class C  

{Method1  m=new method1();}                                {Method2  m=new method2();}               

Side question 1: What happens in below scenario? Does it accepts

Pulic class D

{

Public void method3  (object  A)

{

}

}

Side question 2:  I want to use the methods method1 and method2 through class A in Metho3?

               

10.  What are generics in C#?

Sqlserver

11. What is the use “nolock  “ key word ?

12. Isolation levels?

13.                          Tab1                                                                      Tab2

ID	value
1	D
2	E
6	F

ID	value
1	a
2	b
3	c

               

                What is the o/p for below query?

Side question 1: Select * from tab1, tab2 where t1.ID=t2.ID

Side questions 2: I want the o/p in below format, in how many ways you can achieve

O/P :    use the two tables tab1  and tab2    

ID

1

2

14.  General question, I have a 9 gold bisects among that one is an odd weight, find out the odd one   in three steps?