Subhash DotNet World

Infosys .net Interview Questions

2023-02-15T12:46:00.006+05:30

Infosys .net Interview Questions

2022-Jan

Position :SSE ,Skills : Asp.net Core, C#.net , Oops, Design Patterns ,Sql Server

How do you use dependency Injection in asp.net core ?
Can you please explain DI container service lifetime ?
Can you explain the concept of async programming in C# and give an example of how you have used it in a project?
Can you write a sample Asynchronous programming code to serve the web api request ?
how you would implement security in an ASP.NET Core web application and how can you handle authentication and authorization ?
Can you give an example of how to implement a RESTful API in ASP.NET Core?
Can you walk me through how you would implement unit testing in an ASP.NET Core application using xUnit or MSTest ?
Can you discuss your experience with designing and implementing multithreaded applications in C#?
Can you give an example of using delegates in C#?
Can you write a sample piece of code to query a Employeecontext with dynamic parameters by using lambda expressions, let’s say I have dictionary variable
Eg: Dictionary<string, string> employe=
new Dictionary<string, string>();
employe.Add("EmpName", "Subhash");
employe.Add("Department", "IT");
Can you explain how do you implemented security for web API ?
Ans : I said like we implemented JWT tokens
Can you walk through the how JWT token works ? and how do you validate the token is expired or not ?
How do you identify from execution plan the query is not optimized ?

TCS Dot net interview questions

2017-02-08T18:20:00.001+05:30

TCS Dot net interview questions for experienced Candidates

One of my friend attended TCS dotnet interview in Bangalore. Below is his Interview experience.

First Round of technical Interview:

Interviewer started with, asking about the personal details, work experience and skill rating on asp.net mvc , c#,Oops and sqlserver.

1. How does ‘page lifecycle’ of ASP.Net MVC works?

2. How route table has been created in ASP.NET ASP.Net MVC?

Ans : In short, Method : "RegisterRoutes()" is used for registering the routes which will be added in "Application_Start()" method of global.asax file, which is fired when the application is loaded or started.

3. Why to use "{resource}.axd/{*pathInfo}" in routing in ASP.Net MVC?

4. How can we call a JavaScript function on the change of a Dropdown List in ASP.Net MVC? Asked to write the sample code.

5. How stage-management concept works in asp.net MVC?

Ans : Interviewer asked about the uses of Tempdata, Viewbag, ViewData,Sessions.

6. Does Tempdata hold the data for other request in ASP.Net MVC?

7. Explain Peek method in Tempdata in ASP.Net MVC?

Ans : Similar to Keep method we have one more method called "Peek" which is used for the same purpose. This method used to read data in Tempdata and it maintains the data for subsequent request.

string A4str = TempData.Peek("TT").ToString();

8. How you can send the result back in JSON format in MVC?

Ans : return Json( objCustomer,JsonRequestBehavior.AllowGet);

a9. What are the action filters available in asp.net mvc?

Ans : An action filter is an attribute that you can apply to a controller action -- or an entire controller -- that modifies the way in which the action is executed. The ASP.NET MVC framework includes several action filters.

· OutputCache – This action filter caches the output of a controller action for a specified amount of time.

· Handle Error – This action filter handles errors raised when a controller action executes.

· Authorize – This action filter enables you to restrict access to a particular user or role

10. What methods do we need to overrider to implement custom action filter?

Ans :

1.  OnActionExecuting()

2.  OnActionExecuted()

3.  OnResultExecuting()

4.  OnResultExecuted

11. Can we use multiple models for a single view? How do you achieve this?
No, we can't use multiple models for a single view at a time. But we can handle this scenario, by creating a view model.

12. What are the design patterns followed in your project?

Ans : I said we followed Repository patter, factory pattern

13. What is the single ton pattern? In which scenario we can use singleton pattern?

14. Difference between abstract class and interface?

Sr.No	Abstract Classes	Interface
1	Abstract class can extend only one class or one abstract class at a time.	Interface can extend any number of interfaces at a time.
2	Abstract class can extend from a class or from an abstract class.	Interface can have only abstract methods.
3	Abstract class can have both abstract and concrete methods.	Interface can have only abstract methods.
4	A class can extend only one abstract class.	A class can implement any number of interfaces.
5	Abstract class can have protected public and public abstract methods.	Interface can have only public abstract methods i.e. by default.
6	Abstract class can have static, final or static final variable with any access specifier.	Interface can have only static final (constant) variable i.e. by default.

15. Does the abstract class should contain at least one abstract method?

Ans : No, not required

16. Why we have interface as we can do everything with abstract class?

17. How do you maintain security for your application?

Ans: Since, our applications is an intranet, we used windows authentication

18. How to implement windows authentication? How do you specify roles and permissions to the users?

19. I have 10 text boxes and a button. The button should be enabled only after I have filled the values in all the textboxes. How do you do that?

20. I have a transaction in the database. Inside that, I have a nested transaction. I have written an insert statement and committed. Now in the outer transaction, if I write rollback, will the committed thing inside the nested transaction will be roll-backed?

Please share your interview experiences to my Mail id : nsubhash007@gmail.com

Binding Tree view In Asp.net MVC

2017-02-07T23:10:00.000+05:30

In this article we will see how to bind the tree view in asp.net MVC using Jquery and Bootstrap.

Before starting the implementation, make ensure to get the below prerequisites

Jquery CDN : <script src="https://code.jquery.com/jquery-2.2.4.min.js" integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=" crossorigin="anonymous"></script>
Bootstrap CDN: <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7 /css/bootstrap.min.css" rel="stylesheet" />
CSS for tree view : ( You can download from below link ).
Image: glyphicons-halflings.png (This should get automatically render when referring the bootstrap.css, incase not rendering copy the img file to the solution).

In this article, I’m considering a scenario as, need to display the Portfolio Management Hierarchy, below is how hierarchy is formatted.

1. Portfolio Name

1.1 Program Name

1.1.1 Project Name

1.1.1.1 Project Leader

1.1.1.1.1 Team Members

Here Top level node is portfolio. Portfolio may contain multiple programs and each program may have multiple Projects. Similarly, each project may have multiple project managers and so on.. this hierarchy drill down to till team members.

Step 1: Create a new MVC project.

Step 2: Create a folder “shared” under folder “view” and add the master layout.

Step3: Create a controller “OrganizationHierarchyController.cs” and add a view corresponding to that controller.

Add below lines of code to the newly created view.

CSS:
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" />
<link href="~/Scripts/CustomContent/CSS/Bootstaptreetable.css" rel="stylesheet" />

JavaScript :

<script type="text/javascript">
    $(document).ready(function () {

        var selectedparentnode = null;

        $('.tree li:has(ul)').addClass('parent_li').find(' > span').attr('title', 'Expand this branch');
        $('.tree li ul >li').hide();


        $('.tree li.parent_li > span').on('click', function (e) {
            var children = $(this).parent('li.parent_li').find(' > ul > li');
            if (children.is(":visible")) {
                children.hide('fast');
                $(this).attr('title', 'Expand this branch').find(' > i').addClass('icon-plus-sign').removeClass('icon-minus-sign');
            } else {
                children.show('fast');
                $(this).attr('title', 'Collapse this branch').find(' > i').addClass('icon-minus-sign').removeClass('icon-plus-sign');
            }
            e.stopPropagation();
        });
    });

</script>

HTML Code:

<h2> Binding tree structure Hirearchy </h2>
<div class="col-lg-6">
    <div class="tree well">
        <ul>
            <li>
                <span><i class="icon-folder-open"></i> Portfolio : Heavy machineries and Medical Equipment</span>
                <ul>
                    <li>
                        <span><i class="icon-minus-sign"></i> Program: Heavy machineries </span>
                        <ul>
                            <li>
                                <span><i class="icon-minus-sign"></i> Project : General Motor</span>

                                <ul>
                                    <li>
                                        <span><i class="icon-minus-sign"></i> ProjectLeader : John</span>

                                        <ul>
                                            <li>
                                                <span><i class="icon-leaf"></i> Team Members : 50</span>
                                            </li>
                                        </ul>
                                    </li>
                                </ul>
                            </li>
                        </ul>
                    </li>
                    <li>
                        <span><i class="icon-minus-sign"></i> Program: Medical Equipment </span>
                        <ul>
                            <li>
                                <span><i class="icon-minus-sign"></i> Project : GE HealthCare</span>

                                <ul>
                                    <li>
                                        <span><i class="icon-minus-sign"></i> ProjectLeader : Charles</span>

                                        <ul>
                                            <li>
                                                <span><i class="icon-leaf"></i> Team Members : 50</span>
                                            </li>
                                        </ul>
                                    </li>
                                </ul>
                            </li>

                            <li>
                                <span><i class="icon-minus-sign"></i> Project : GE Life sciences </span>

                                <ul>
                                    <li>
                                        <span><i class="icon-minus-sign"></i> ProjectLeader : Mike</span>

                                        <ul>
                                            <li>
                                                <span><i class="icon-leaf"></i> Team Members : 30</span>
                                            </li>
                                        </ul>
                                    </li>
                                </ul>
                            </li>
                        </ul>
                    </li>

                </ul>
            </li>

        </ul>
    </div>
</div>

<div class="col-md-6">
    <div>

    </div>
</div>

Binding tree view through programmatically

https://dotnetkudos.blogspot.in/2017/02/binding-tree-view-in-aspnet-mvc.html

Capgemini Dotnet Interview Questions

2016-12-28T19:00:00.000+05:30

Capgemini Asp.net MVC Interview Questions

Hi Friends,

One of my friend attended Dotnet Interview at Capgemini, Mumbai Location. Below are the Questions, Hope these questions may helpful for the people who are searching for a Job.

Interview is conducted for 4-6 years of experience on Asp.net MVC, C# and sql server.

First round Technical Questions.

1. What are the Design patterns used in your project? What is the advantage of using Dependency Injection?

2. Tell about your project architecture? How do you call Entities?

3. For Ex : I have two classes, customer and CustomerAddress , How do you Initialize lazy loading ?

4. Consider a class "Customer" having below fields CustomerID, CustomerName, Age, Gender, email, and mobileno Write a query lambda expression to filter customer details (CustomerID, CustomerName, email and Mobile No ,exclude Gender and age) having age greater than 20.

5. Difference between var and dynamic key word?

6. What are Delegates in C# ? Explain with a Scenario where we can use Delegates?

7. How to create custom event Handlers?

8. What are collection classes in C#? Name few of the collection classes?

9. Difference between collection classes and Generic collection classes? What are the advantages of Generic collections?

https://msdn.microsoft.com/en-us/library/mt654013.aspx

10. What are Action filters in MVC?

11. How Routing works In MVC?

12. Different ways to handle exceptions ? How do you Implemented Exception handling in your project ?

13. Can you tell any three differences between EntityFrame work and Dapper classes?

Sql Server :

1. What is the use of CTE ?

2. When to use @table variable and temp table?

3. What steps do you consider while Optimizing Query ?

4. Interviewer provided laptop and asked to write a Query from below table

Retrieve count of different statuses, month wise

RequestSubject	RequestDetails	Status	CreatedDate
PaymentFailed	PaymentFailed	New	14-10-2016
Transaction Error	Transaction is failed due to techinical error	WIP	14-10-2016
InSufficent Funds	Transaction is failed due to InSufficient funds	Completed	17-10-2016
OrderNotRecevied	Still awaiting for the Order	WIP	20-10-2016
PaymentFailed	Transaction Declined due to Insufficient funds	Completed	21-10-2016
Transaction Error	Unable to place an order	New	02-11-2016
Fund transfer	Failed to transfer funds	WIP	03-11-2016
PaymentFailed	Transaction failed due to technical issues	New	11-11-2016
Order Cancelled	Order cancelled in valid communication address	Completed	15-11-2016

Expected Output:

Status	Count	Month
NEW	1	Oct-16
WIP	2	Oct-16
Completed	2	Oct-16
NEW	2	Nov-16
WIP	1	Nov-16
Completed	1	Nov-16

Search a key word or Text in Sql server

2015-01-03T20:17:00.001+05:30

It's quite often in real time require to search for a particular word or text that used in stored procedure and function . There are couples of way getting dependency objects in sql server. But, this article follows bit different approach getting dependencies of the objects especially when a table name or column is formatted in a string variable, for example ,see the below procedure where table name and column names are embedded in a string variable, In this situation we can't get the information of the object where table "Tab_Empolyee" is used in sql server not even with the built in feature "View Dependencies".

CREATE PROCEDURE GetEmpolyeeDetails

/* Modification History

---- Modifiedon ChangesDescription

2014-12-31 New Procedure created

BEGIN

DECLARE @SqlString VARCHAR(200)

SET @sqlString='select EmpID,EmployeeName from Tab_Employee'

EXEC(@sqlString);

END

Here, I would like to know list of procedures/Objects that are using table name "Tab_Employee" , for that I written a small query that accepts a key word or text to search and returns the list of objects where that key word is used.

DECLARE @String varchar(50)='Tab_Employees'

DECLARE @Used TABLE (name VARCHAR(1000),Line VARCHAR(7000))

SELECT @String=REPLACE(REPLACE(REPLACE(@String,'%','[%]'),'_','[_]'),'-','[-]')

INSERT INTO @Used

SELECT DISTINCT name,text FROM sysobjects o join syscomments c ON c.id = o.id

WHERE text LIKE '%' + @String + '%'

UNION

SELECT 'ParentObject: '+Parent.name+ ' for: '+o.name,text FROM sysobjects o join syscomments c ON c.id = o.id

JOIN syscolumns depend ON depend.cdefault=o.id

JOIN sysobjects Parent ON Parent.id=depend.id

WHERE text LIKE '%' + @String + '%'

SELECT * from @Used

from the above query it is giving the result where field 'name' represents object name like 'storedproc or func.

Well you can also find out words or phrases that used in comments section.

Syntel Dotnet Interview Questions

2012-10-28T15:20:00.002+05:30

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

First round techincal

What is unity container in MVC
WCF Architecture
Explain Razor View engine
What different Types of Contracts in WCF and why it necessary to use Contracts
Explain Serialization in WCF
Which is fast DataContract or XML Serialization
What is opt in seralization
write down the wcf service for customizing SOAP Header
What is group hierarchical Join in LINQ
What is difference between Iquerable and IEnumerable
Featurs of ORACS framework

Second round technical

Explain Transaction in WCF or write the service including transaction
Can we used transaction in basic http binding or in webservice
Write the WSDL Documents for particular service (He given one simple service right now i don't remember)
Types of Hosting in WCF?
Give the practical example of Self Hosting in WCF how u host the service WAS
Different layeres in WCF
Why organization using wdfederation2007http binding

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

Deloitte Dotnet Interview Questions

2012-10-28T15:03:00.000+05:30

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

Difference between HTML Control and Server Control
Can you write down the Stack program in CSharp
Can you write down the binary search algorithm
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
What is meaning of assembly
how to make the assembly public write the strongly type commands
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
Difference between hashtable and arraylist
What are Generics ?

C. SQL

What is equijoin
In SSRS, explain the grouping concept
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

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

2012-06-03T11:58:00.000+05:30

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?

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

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

Igate Patni Dotnet Interview questions

2012-01-26T10:59:00.000+05:30

Igate Patni 3+ Dot net interview questions

1. Difference between frame work 2.0 3.0, 3.5 and 4.0? Currently which frame work ur using ?

2. Use of LINQ ?

Any experience on wcf ?

3. Difference between message contract and data contract?

4. How many ways your handling the exceptions in service? for eg: how your handling exceptions if your service is returning null values, passing string values instead of int variable..

5. What happens if your services are responding slowly or sometimes you may receive the service unavailable how you handle this situation?

6. Can I able to access the methods which are not specified as Data Contract?

7. What is difference between view state and control state?

8. I have webform1 and webform2 , I want to access all the values of webpage 1 controls in webpage2( Without using session) ? I said: if we use server .transfer ()we can access all previous page controls values in current page.

Side question: how and where these values are stored? I said: values stored in view state?

How these values(webform1 and webform2 ) stored in view state?

9. Can I use multiple web.config file in single project and my project does not contains any subfolders?

10. You developed two web forms and how you can say that your code following coding standards?

11. Use of static classes? What is the use of constructors?

12. What is the use of Interface and abstract classes? Without these concepts also we can write the code, but still why we are using interface and abstract class what is the necessity?

13. What is partial post back and asynchronous request?

14. Write a sample code for print the name “Subhash” as “hsahbus” without using reverse function?

15. Difference between array list and array?

16. What is meant by denormalization?

17. What is meant by reflection, showding?

18. Give a scenario where we use custom validation?

19. I have a label inside update panel and a button outside UP, in button click event I ‘m assign the value to the label, does it reflect? (yes/No) with reason?

20. What are extension methods?

21. Difference between html and xml? What is the necessity of using xml ?

22. I have a method, how many different ways can you call that method asynchronously?

23. What is serialization and deserialzation?
24. What are http modules? can you tell what are the http modules that we are using in daily routine?

Accenture Dotnet Interview Questions

2011-07-16T15:14:00.001+05:30

Accenture 2+ dot net interview questions,Bangalore

1.Tell about your Current project? How the security is implemented , which architecture does you used ?

2. What are the various technologies you used in current and in previous projects

I said: VS2005,VS2008, Sql server 2000,2005,java script ,Ajax, j queries, WCF.

3. What is the difference between abstract class and interface? Where we use abstract class and interface?

4. I want a method which it should return a string variable, Boolean variable and integer variables, how do you implement that method?

Eg: I'm passing date time to method that method should return date , hrs,minutes and it should check date should not less than today's date and return as boolean.

I said yes we can implement such a methods, by using key word “out “.

public string getdatetime(string frmDatetime, string out date,int out hrs,int out mints,Boolean Isvalid)

5. Can we use “out” for the methods of type void? Does it give any compilation or run time error?

I said: yes we can use for methods of type void also. I does not give any type of errors.

6. What are sealed classes and static classes?

7. What is boxing and unboxing?

8. Why do I'm get an error while try to declare the method?

public static staticMethod (mainStatic obj)

I said: yes it will give compilation error without specifying return type.

public static void staticMethod (mainStatic obj)

9.Let's consider a scenario, I have a Text box when user enter a number in text box, I need to display the employee's details based on empid; if user enters a string value I need to display based on emp name.

10. Does C# supports the properties for array types?

I said : yes ,it supports

for eg:

class Class1

{

private string[] MyAssesrts;

public string[] SubhashProperties

{

get { return MyAssesrts; }

set { MyAssesrts = value; }

}

class MainClass

{

public static int Main(string[] args)

{

Class1 c = new Class1();

string[] arr = new string[] {"car", "villa",”land”};

c. SubhashProperties = arr;

Console.WriteLine(c.SubhashProperties [0]);

return 0;

}

12. You worked on jquries right? What are the various features it overcomes from JavaScript and Ajax?

13. How to find the text box of id txtname in jquery?

14. What is SOA? Difference between web services and WCF?

15. How do you deploy the web services and WCF in production server?

16. What are the page life cycle events?

17. In Page load () Does it possible to identify , by which control or event causes post back

I said: up to my knowledge No, we cannot identify, in page load all the controls and events will be loaded.

I'm not sure whether it is a right answer or not?

17. What are http handlers? Where we use?

18. I need to insert the data of uploaded excel file to sqlserver, In how many ways we insert?

I said:

First we need to open the oledb connection, query the excel sheet and get excel data to data table or dataset.

A. we can loop each row form a insert query a string and Executenonquery ().

B.loop each row collect the data in array lists after looping the all records we can pass the array values to stored procedure.

C. We can use sql bulk upload utility class, where we insert all the data at a time from data table to backend DB.

19. So, among these which one is the best you feel?

I Said: obviously, third one gives the better performance.

20. How do you validate the data before inserting the data through sql bulk upload?

21. I’m uploading a large amount of data, my excel sheet contains @ 60000 to one lakh records,

22. What happens if I got any connection time out error or some other error occurs, how do you handles this error.

I said: I faced this situation in my project, first of all we should not allow to the uploading large amount of data we should consider the file size before user uploading, better to allow uploading the small chunks of data , we should also consider production server configuration,

Sqlserver:

21. How do you handle errors in stored procedures?

I Said: In sql server 2005 and 2008 have a better error handling capable when compare to sqlserver2000, we can use try catch blocks in stored procedures.

And also we can use @@Error which is a global variable;

I explained about error_message (), error_seveority, error_description ().error_id()

22. Why we need to specify NoLock? Do we use Nolock while performing the DML operations, what happened if use?

I said: Nolock should specify after the table name while performing the select statement, by default while executing the select statement sqlserver lock the table, for eg my query takes 6 sec to execute these 6 sec sq server will not allow to perform the any other DML Operations on that table

i don't know whether this is a right or not....

Project Manager Round

How much years of experience do you have?

Where you’re working, from how many years your working with present company?

What are projects you handled, what is the project you feel this is very tough project?

What you feel that much of toughness in this project?

Did you interact with the client at any time?

How Do you get the domain knowledge?

Thanks Pratik Agrawal ! for Sharing your interview Experince

Please Send your dotnet interview experinces to my mail id: nsubhash007@gmail.com

My Favourite Quotes

2011-07-07T20:35:00.006+05:30

Rabindranath Tagore Geetanjali in Telugu

Where the mind is without fear and the head is held high;
Where knowledge is free;
Where the world has not been broken up into fragments by narrow domestic walls;
Where words come out from the depth of truth;
Where tireless striving stretches its arms towards perfection:
Where the clear stream of reason has not lost its way into the dreary desert sand of dead habit;
Where the mind is lead forward by thee into ever-widening thought and action —
Into that heaven of freedom, my Father, let my country awake.

ఎక్కడ మనస్సు

నిర్భయంగా వుంటుందో , ఎక్కడ మనిషి సగర్వముగా తల ఎతుకొని తిరగలడో ,

ఎక్కడ ప్రపంచం ముక్కలు ముక్కలు అయి మగ్గిపోదో ,

ఎక్కడ మన చదువు విజ్ఞానం ముడనమ్మకలో ఇంకిపోదో ,

ఎక్కడ ఒక మనిషి సాటి మనిషిని దోచుకోడో,

అక్కడ అ స్వెచా స్వతంత్రమ్ లొ కి దెవుడా నా ఈ దేశాన్ని మెల్కొలుపు............!!!!.!

~ Rabindranath Tagore ~

(Gitanjali)

Polaris Dotnet Interview Questions

2011-06-19T14:01:00.000+05:30

Explain about your current project?
Which type of architecture is used and how the security is implemented in your project?
Rate yourself in asp.net, C#, Sqlserver, Ajax?

I said 4,4,3,4

What is partial page post back?
Let’s consider a button inside the update panel and a label outside the update panel, h’w can I update the label control on button click event?
Consider a button inside the update panel which is calling java script function on button click event, but java script is not executing when user clicks on the button what could be the reason? How you make it to work?
Consider a webpage is loading very slowly in production, how do you identify the reasons why it is loading slowly…

Interviewer asks many side questions like how you optimize the C# code, sql queries, does sql functions cause any performance issues.

Difference between web services and WCF?
How do you host the WCF?
What is a service contract and data contract?
How can you rate yourself in JavaScript and oops?
How to convert a string variable to int in java script?
Side how do you debug the java script code?
How do you overcome the browser incompatible issues..?
Difference between ref and out?
Where should we use Interface and where should we use abstract classes?
Can you tell me what are best Programming practices that you are implementing in your projects…?
Does writing the try, catch blocks in the code causes any performance issues?

Sql Server

What is the difference between Lock and no lock?
Write the syntax for case statement?
Types of joins?
Triggers, Stored procedures

Please send your dot net interview experinces to my mail id: nsubhash007@gmail.com

CTS Dotnet Interview Questions

2011-03-20T14:10:00.001+05:30

CTS Dotnet Interview Questions

1. Ca n you explain the page life cycle event in asp.net?

2. How can I apply the themes and skin to WebPages..?

3. What is the Auto Event wired property?

4. Is web.config file is mandatory to run the web application?

No, but it is always better to choose the Web.config file

5. What are the features of config file you have used?

6. How I can use web.config file for error handling?

7. Take the scenario where I’m not using web.config file in my application, is there any other place where I can write the connection string?

8. I want to display the some data from two different data sources ,say sql server,ms access ; can you tell me the steps to display data on webform ?

9. I want to display a data in gridview (Paging also)? Which one is the good either data set or data reader?

10. Difference between data reader and data set? What is meant by forward cursor only?

11. How to use update panel?

12. What is the use of script manager? I have master page and content page in which page I need to use script manager?

13. You have any experience in wcf? What is SOA?

Oops

14. What are the static classes?

15. Can static classes contain non static members?

16. Method overloading and method overriding where you implemented in your project?

Sql Server

17. What is the composite key?

18. Did you face any performance issues in your application? Let us say a web page loading very slow ly? How you speed up the webpage

19. How you will the optimize the query? What are the steps you will take?

20. Date Diff function?

21. What is the use of cursors?

22. Table 1 : empid(pk), empname ,deptid(fk)

Table2: deptid(pk) ,deptname

Count of employees in each department?

Please Send your Interview Experiences To Mail id: nsubhash007@gmail.com

TCS Dot net Interview Questions

2010-12-12T21:29:00.000+05:30

TCS .net interview Questions, part-2

1)Code for updating the database by entering the data into textboxes in

aspx form?

2)How do you handle errors in stored procedures?

3)How did you implemented classes in your project?

4)How did you implemented interfaces in your project?

5)How did you call javascript from c#?

6)Differences between 1.1 and 2.0 versions of .net?

7)Caching types?

8)Session state modes?

9)what is the connection between IIS and client browser?

How do they communicate?

10)which session statemode u used in your current project?why?

11)How did you handle exceptions in sql server?

12)Two methos with same name in parent and inherited classes. If you create

an objct of child which method will be invoked?

13)Garbage colllector how it works in Background?

For other dot net interview Questions

Sqlqueires best practices
TCS Dotnet interview Questions Part1
HCL Dot net interview Questions
Prokarma Dotnet interview Questions
Mphasis Dotnet interview Questions

TCS dot net interview Questions

2010-12-12T21:18:00.000+05:30

TCS Dot net interview Questions, 3+ years of experince , Hyderabad ,part-1

1) How do u implement windows authentication, explain me each and every step in point of web.config and iis.

2) what is impersonization.

3) what is HTTP Handlers

4) What is http Modules

5) can we have our own extension of .net page i.e. for example
.asgx

6) what is Delay signing

7) what is Application pooling

8) Difference between finalize and dispose

9) Expalin Generics

10) Explain difference between Arraylist and Hashtable.

11) what is probing

12) what is multi targetting framework

13) what is difference between usercontrol and custom control

14) what is the difference between master page and user control.

15) how can we use old dll and new dll in our application

16) given some values and asked me to sort it in ascending order with out

using Array list methods like sort.

17) what is dataset and typed dataset.

18) what are the necessary steps u will take care to increase the performance of ur asp.net web application.

19) hOW do u find out errors in sql stored procedures.

20) how do u work with sqljobs.

21) Consider a scenario there are 2 systems in lan, one is ur local host and other is mine how do u access my database and tables.

22) do u know SSIS,SSRs.

23) what is dictionary and what is list and the differences between them

Hi Friends Please share your interview questions with me
Email id : nsubhash007@gmail.com

For Other Dotnet Interview Questions

Accenture Dot net interview Questions

Dell Dot net interview Questions
Value labs Dotnet interview Questions
Infotech enterprises Dotnet interview Questions

Sql Queries For Best Practices

2010-12-05T19:28:00.000+05:30

Sql quires for Interview preparation and for best practices

Answers for the Sql queries

1. SQL > Select * from employee;

2. SQL > Select * from department;

3. SQL > Select * from job;

4. SQL > Select * from loc;

5. SQL > Select first_name, last_name, salary, commission from employee;

6. SQL > Select employee_id “id of the employee”, last_name “name", department id as “department id” from employee;

7. SQL > Select last_name, salary*12 “annual salary” from employee

8. SQL > Select * from employee where last_name=’SMITH’;

9. SQL > Select * from employee where department_id=20

10. SQL > Select * from employee where salary between 3000 and 4500

11. SQL > Select * from employee where department_id in (20,30)

12. SQL > Select last_name, salary, commission, department_id from employee where department_id not in (10,30)

13. SQL > Select * from employee where last_name like ‘S%’

14. SQL > Select * from employee where last_name like ‘S%H’

15. SQL > Select * from employee where last_name like ‘S___’

16. SQL > Select * from employee where department_id=10 and salary>3500

17. SQL > Select * from employee where commission is Null

18. SQL > Select employee_id, last_name from employee order by employee_id

19. SQL > Select employee_id, last_name, salary from employee order by salary desc

20. SQL > Select employee_id, last_name, salary from employee order by last_name, salary desc

21. SQL > Select employee_id, last_name, salary from employee order by last_name, department_id desc

22. SQL > Select department_id, count(*), from employee group by department_id

23. SQL > Select department_id, count(*), max(salary), min(salary), avg(salary) from employee group by department_id

24. SQL > Select job_id, count(*), max(salary), min(salary), avg(salary) from employee group by job_id

25. SQL > Select to_char(hire_date,’month’)month, count(*) from employee group by to_char(hire_date,’month’) order by month

26. SQL > Select to_char(hire_date,’yyyy’) Year, to_char(hire_date,’mon’) Month, count(*) “No. of employees” from employee group by to_char(hire_date,’yyyy’), to_char(hire_date,’mon’)

27. SQL > Select department_id, count(*) from employee group by department_id having count(*)>=4

28. SQL > Select to_char(hire_date,’mon’) month, count(*) from employee group by to_char(hire_date,’mon’) having to_char(hire_date,’mon’)=’jan’

29. SQL > Select to_char(hire_date,’mon’) month, count(*) from employee group by to_char(hire_date,’mon’) having to_char(hire_date,’mon’) in (‘jan’,’sep’)

30. SQL > Select to_char(hire_date,’yyyy’) Year, count(*) from employee group by to_char(hire_date,’yyyy’) having to_char(hire_date,’yyyy’)=1985

31. SQL > Select to_char(hire_date,’yyyy’)Year, to_char(hire_date,’mon’) Month, count(*) “No. of employees” from employee where to_char(hire_date,’yyyy’)=1985 group by to_char(hire_date,’yyyy’),to_char(hire_date,’mon’)

32. SQL > Select to_char(hire_date,’yyyy’)Year, to_char(hire_date,’mon’) Month, count(*) “No. of employees” from employee where to_char(hire_date,’yyyy’)=1985 and to_char(hire_date,’mon’)=’mar’ group by to_char(hire_date,’yyyy’),to_char(hire_date,’mon’)

33. SQL > Select department_id, count(*) “No. of employees” from employee where to_char(hire_date,’yyyy’)=1985 and to_char(hire_date,’mon’)=’apr’ group by to_char(hire_date,’yyyy’), to_char(hire_date,’mon’), department_id having count(*)>=3

34. SQL > Select * from employee where salary=(select max(salary) from employee)

35. SQL > Select * from employee where department_id IN (select department_id from department where name=’SALES’)

36. SQL > Select * from employee where job_id in (select job_id from job where function=’CLERK’

37. SQL > Select * from employee where department_id=(select department_id from department where location_id=(select location_id from location where regional_group=’New York’))

38. SQL > Select * from employee where department_id=(select department_id from department where name=’SALES’ group by department_id)

39. SQL > Update employee set salary=salary*10/100 wehre job_id=(select job_id from job where function=’CLERK’)

40. SQL > delete from employee where department_id=(select department_id from department where name=’ACCOUNTING’)

41. SQL > Select * from employee where salary=(select max(salary) from employee where salary <(select max(salary) from employee))

42. SQL > Select distinct e.salary from employee where & no-1=(select count(distinct salary) from employee where sal>e.salary)

43. SQL > Select * from employee where salary > all (Select salary from employee where department_id=30)

44. SQL > Select * from employee where salary > any (Select salary from employee where department_id=30)

45. SQL > Select employee_id, last_name, department_id from employee e where not exists (select department_id from department d where d.department_id=e.department_id)

46. SQL > Select name from department d where not exists (select last_name from employee e where d.department_id=e.department_id)

47. SQL > Select employee_id, last_name, salary, department_id from employee e where salary > (select avg(salary) from employee where department_id=e.department_id)

48. SQL > Select employee_id, last_name, name from employee e, department d where e.department_id=d.department_id

49. SQL > Select employee_id, last_name, function from employee e, job j where e.job_id=j.job_id

50. SQL > Select employee_id, last_name, name, regional_group from employee e, department d, location l where e.department_id=d.department_id and d.location_id=l.location_id

51. SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name

52. SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name having name=’SALES’

53. SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name having count (*)>=5 order by name

54. SQL > Select function, count(*) from employee e, job j where j.job_id=e.job_id group by function

55. SQL > Select regional_group, count(*) from employee e, department d, location l where e.department_id=d.department_id and d.location_id=l.location_id and regional_group=’NEW YORK’ group by regional_group

56. SQL > Select employee_id, last_name, grade_id from employee e, salary_grade s where salary between lower_bound and upper_bound order by last_name

57. SQL > Select grade_id, count(*) from employee e, salary_grade s where salary between lower_bound and upper_bound group by grade_id order by grade_id desc

58. SQL > Select grade_id, count(*) from employee e, salary_grade s where salary between lower_bound and upper_bound and lower_bound>=2000 and lower_bound<=5000 group by grade_id order by grade_id desc

59. SQL > Select e.last_name emp_name, m.last_name, mgr_name from employee e, employee m where e.manager_id=m.employee_id

60. SQL > Select e.last_name emp_name, e.salary emp_salary, m.last_name, mgr_name, m.salary mgr_salary from employee e, employee m where e.manager_id=m.employee_id and m.salary

61. SQL > Select m.manager_id, count(*) from employee e, employee m where e.employee_id=m.manager_id group by m.manager_id

62. SQL > Select last_name, d.department_id, d.name from employee e, department d where e.department_id(+)=d.department_id

63. SQL > Select last_name, d.department_id, d.name from employee e, department d where e.department_id(+)=d.department_id and d.department_idin (select department_id from department where name IN (‘SALES’,’OPERATIONS’))

64. SQL > Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name=’SALES’)) union Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name=’ACCOUNTING’))

65. SQL > Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name=’SALES’)) union all Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name=’ACCOUNTING’))

66. SQL > Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name=’RESEARCH’)) intersect Select function from job where job_id in (Select job_id from employee where department_id=(select department_id from department where name=’ACCOUNTING’)) order by function

Sample Sql Queries For Practices

2010-12-02T12:29:00.004+05:30

Sample Sql Queries for best practices

Create the following Tables:
Table1 :Location

Table2 :Department

Table 3: Job

Table 4: Employee

http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html

Simple Queries:

1. List all the employee details

2. List all the department details

3. List all job details

4. List all the locations

5. List out first name,last name,salary, commission for all employees

6. List out employee_id,last name,department id for all employees and rename employee id as “ID of the employee”, last name as “Name of the employee”, department id as “department ID”

7. List out the employees anuual salary with their names only.

For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html

Where Conditions:

8. List the details about “SMITH”

9. List out the employees who are working in department 20

10. List out the employees who are earning salary between 3000 and 4500

11. List out the employees who are working in department 10 or 20

12. Find out the employees who are not working in department 10 or 30

13. List out the employees whose name starts with “S”

14. List out the employees whose name start with “S” and end with “H”

15. List out the employees whose name length is 4 and start with “S”

16. List out the employees who are working in department 10 and draw the salaries more than 3500

17. list out the employees who are not receiving commission.

For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html
Order By Clause:

18. List out the employee id, last name in ascending order based on the employee id.

19. List out the employee id, name in descending order based on salary column

20. list out the employee details according to their last_name in ascending order and salaries in descending order

21. list out the employee details according to their last_name in ascending order and then on department_id in descending order.

For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html
Group By & Having Clause:

22. How many employees who are working in different departments wise in the organization

23. List out the department wise maximum salary, minimum salary, average salary of the employees

24. List out the job wise maximum salary, minimum salary, average salaries of the employees.

25. List out the no.of employees joined in every month in ascending order.

26. List out the no.of employees for each month and year, in the ascending order based on the year, month.

27. List out the department id having atleast four employees.

28. How many employees in January month.

29. How many employees who are joined in January or September month.

30. How many employees who are joined in 1985.

31. How many employees joined each month in 1985.

32. How many employees who are joined in March 1985.

33. Which is the department id, having greater than or equal to 3 employees joined in April 1985.
For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html
Sub-Queries

34. Display the employee who got the maximum salary.

35. Display the employees who are working in Sales department

36. Display the employees who are working as “Clerk”.

37. Display the employees who are working in “New York”

38. Find out no.of employees working in “Sales” department.

39. Update the employees salaries, who are working as Clerk on the basis of 10%.

40. Delete the employees who are working in accounting department.

41. Display the second highest salary drawing employee details.

42. Display the Nth highest salary drawing employee details.

For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html

Sub-Query operators: (ALL,ANY,SOME,EXISTS)

43. List out the employees who earn more than every employee in department 30.

44. List out the employees who earn more than the lowest salary in department 30.

45. Find out whose department has not employees.

46. Find out which department does not have any employees.

For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html
Co-Related Sub Queries:
47.Find out the employees who earn greater than the average salary for their department.

Joins

Simple join

48.List our employees with their department names

49.Display employees with their designations (jobs)

50.Display the employees with their department name and regional groups.

51.How many employees who are working in different departments and display with department name.

52.How many employees who are working in sales department.

53.Which is the department having greater than or equal to 5 employees and display the department names in ascending order.

54.How many jobs in the organization with designations.

55.How many employees working in “New York”.

For Answers : http://subhashnetworld.blogspot.com/2010/12/sql-queries-for-best-practices.html

Non – Equi Join:

56.Display employee details with salary grades.

57.List out the no. of employees on grade wise.

58.Display the employ salary grades and no. of employees between 2000 to 5000 range of salary.
Self Join:

59.Display the employee details with their manager names.

60.Display the employee details who earn more than their managers salaries.

61.Show the no. of employees working under every manager.

Outer Join:

61.Display employee details with all departments.

62.Display all employees in sales or operation departments.

Set Operators:

63.List out the distinct jobs in Sales and Accounting Departments.

64.List out the ALL jobs in Sales and Accounting Departments.

65.List out the common jobs in Research and Accounting Departments in ascending order.

Value labs Dotnet Interview Questions

2010-11-22T22:55:00.003+05:30

Dotnet interview with ValueLabs,Hitechcity,Hyderabad, for 2-4 years exp.

It was a written test with 10 questions and time is 90 mins.

here are the questions:

1.How can we force Garbagecollector to run?

2.How many authentication modes are there?what is the default mode?

3.Windows API calls in .net?

4.ExpressionLambdas and their syntax?

5. What is section in webconfig?

6.What is the use of static constructor?Can we have multiple Static Constructors?

7.What is the extension of LINQ file that interacts with code behind objects?

8.How to insert multiple rows from Gridview to Database table under a single transaction?

9.Retrieve distinct values from L and order values based on username using LINQ.

Hi Santoash, thnxa lot for sharing your Interview experinces..

Hi Friends Please send your interview experinces to mail id: nsubhash007@gmail.com

Dell Dotnet Interview Questions

2010-11-02T10:24:00.001+05:30

Dell Dot net Interview Questions for 2+ years of Experience
1. Explain about your project briefly?

2. Explain briefly about Exception handling? How did you handle the exceptions in your project?

3. Use of finally block and Throw keyword?

4. What are the various Client Side State management Concepts?

5. Difference between Session and View State

6. Difference b/w authentication and authorization.

7. What is Application Domain?

8. What is Http handler?

9. Authentication modes?

10. Difference between Abstract class and sealed class?

11. What are access modifiers?

12. What are Partial Classes?

13) Do you have any awareness on Linq, wcf?

14) Is it possible to update the table in functions?

15) Difference between Stored procedure and function, stored procedure and query?

16) Product table

Product_Id Product_Name Category_Id

1000 Samsung 100

1001 Oneida 100

1002 Sony 100

1003 Nokia 101

1004 LG GX500 101

Category table:

Category_Id Category_Name

100 TV

101 Mobile

102 Laptops

Write the query for in order to show the O/p

Category_Name Product_Name

100 Samsung, Onida, Sony

101 Nokia,LGgx500

Vidya Sri Thanks a lot for sharing your interview experience with dell, hope these are helpful those who are looking for a job
Please send your Interview Experinces on Dot net and Share point to my mail id: nsubhash007@gmail.com

Mind Tree Dotnet Interview Question

2010-10-01T18:39:00.000+05:30

Mind tree Dot net interview Questions, Bangalore, Sept 1, 2010

1) I have the string in format of Rs.2, 50,000. Now I want to read the string value as 250000 and insert into database (let assume that Rs 2,50,000 coming from third party like web services, wcf services, or from other application ) can u write the code to remove the commas.

2) Can a stored procedure call another stored procedure?

3) Difference between function and stored procedure?

4) How can you know the number of rows affected by last SQL statement?

5) What is the use of COMMIT TRANS?

6) What are cursors?

7) Types of indexes?

8) What is the purpose of UPDATE STATISTICS?

9) Can u write the code for , I have the date time columns in data base which it stores in the format of date time 01/09/2010 10:02:56 now I want to display the date as 1- sept-2010 ?

10) How do you find the duplicate rows in the table?

11) What is a typed dataset?

12) What are collection classes?

Array list, dictnory…,

Can u tell me the use of dictionary data type?

13) What are generics?

14) What is the use of Partial Classes

15) What is the use of Enum data type?

Side question: it is reference type r value type?

15) For ex I have

Public enum
{

Sunday =1;

Monday=2;

Tuesday=3;

Wednesday=4;

.

.

.

}

I need to fill this into dropdown list?

16) How the security is implemented in your project?

I told like, by implementing the 3-tier architecture, using forms authentication, encrypting the password, query strings.

Interviewer how you encrypt the password, I mean which approach u choose, or client specified particular process. .. Can u tell me how many methods you know to encrypt

17)I have string value like “This is Subhash” now I want to spilt the word at white spaces and collect the words into array list?

18) I have a webpage with some text boxes and one button with name refresh, when I click the button all the textboxes should get refresh, how can u achieve this?

In button event we can write the textbox1.text=”” or text.clear();

Side question if I have 25 control in my webform then for 25 controls you will write text. text=”” ------ so on.

How much u can rate Ur self in asp.net out of 5---

19) Does a form authentication is work when cookies are turn off at browser side? H’w can u achieves the forms authentication?
20) Difference between forms authentication and windows authentication?
Side why windows authentication is more secured when compare to forms authentication

21) Can u write the query for to retrieve all records which are modified in last 10 days?

Thanks Varun for sending ur valuable interview questions, hope these are very helpful to my blog readers ...

Please the Send Your Dotnet and Sharepoint Interview Experinces to my maild: nsubhash007@gmail.com

Previous Dotnet Interview Questions

HCL Dotnet Interview Questions
Infosys Dotnet Interview
Satyam Mahindra Dotnet Interview Questions
Mphasis Dotnet Interview
Prokarma Dotnet Interview Questions

Infotech-enterprises Dotnet Interview Questions

2010-09-09T17:40:00.003+05:30

InfoTech Enterprises Dotnet interview Questions, Aug28 2010, Hyderabad
1. What are the principals of oops?

2. What is an abstract class?

3. Purpose of abstract class?

4. Can static classes be abstract?

5. What is a session obj?

6. Avd and dis of stored procedures?

7. Diff btwn sp and functions w.r.t to database and c#?

8. Masterpagefile attribute?

9. Can sp be nested?

10. Can sp include two tables?

11. What is a view state and in which context does u use it?

12. Diff b/w interfaces and abstract classes?

13. What happens between request and response?

14. “Select * from tab”, sql function to search f in that query?

Search “f” in the string……

15. What is a package?

16. What is a trigger?

17. Types of triggers?

18. Tell me about ur project and modules involved?

Project Manager Round:

Interviewer: Can u tell me abt Ur project, what are the module u involved, did u face any typical task in Ur project,How you get the requirement from your boss?
If u fall behind the schedule then how u over come
Do have any experience on gps, or showing the Google maps in your project?

This is For 2+ years of Experience, one of my Friend Sucheta Reddy has shared these Interview Questions, Iam Very thankful to her, for this great job.

Please Send Your Dotnet and Share point Interview Experiences to mail id: nsubhash007@gmail.com

For Wipro Dotnet Interview Questions         Click here
        Prokarma Dotnet Interview Questions   Clickhere
       Accenture Dotnet Interview Questions   Clickhere
       Deloitte Dotnet Interview Questions        Clickhere

Wipro Dotnet Interview Questions

2010-08-20T16:10:00.001+05:30

Wipro Dotnet Interview Questions

1. Can u tell me how iis server process the page request?

2. What are the http handlers?

3. Page life cycle events

4. When can we override the Page_Init() ? (i.e. any example in which scenarios )

5. What is u r current project ….. ? Which type of architecuture is Implemented ?

6. Did u ever face any critical task in u r Project, if so , how did you face the task.

7. Difference between data table and data view?

8. Can we filter the data directly to dataset (with out using Linq)

9. What are the advantages of using the LINQ Expressions?

10. Is it possible to query groupby without Using LINQ

11. Can u write the groupby expression for data table by using Linq.

12. Can u write the code for ex : I have the dropdown list cites with names, Hyderabad, Mumbai, Chennai and other , when I select the option other textbox should be enabled with out post back using JavaScript ?

13. Difference between Jquery and JavaScript?

14. What do you mean by replication?

15. Can u write the query I have a table with some duplicate rows, I want to know the rows which are duplicate.

16. Difference between Stored Procedure and Function?

17. Difference between Cluster Index and NonCluster Index? Can u explain how Performance improves

18. What is meant by Self Join?

19. What is a value type and reference type?

Is string is a Value type or reference type

20. String and String builder differences What are Sealed Classes

21. What are Sealed Classes?

22. Advantages of using the Partial Classes

Wipro Dotnet Interview Question for 2+ years experince , Hyderabad ,July 2010.

Please Share Your Interview Experinces
nsubhash007@gmail.com

Prokaram Dotnet Interview Questions

2010-06-06T13:28:00.002+05:30

Prokarma Dotnet Interivew Questions,Hyderabad

1) 1) Tell me abt ur project .. ? Roles and Responsibilities

2) 2) What is meant by 3-tier architecture ?

3) 3) What is use of 3-tier architecture ? Difference between 3-tier architecture and 3layerd architeture

4) 4) What does business logic layer and dataacess layer cantains ?

5) 5) Take simple form in ur project , explain how data is acess ( what r the methods u called for inserting the values, passing the parameters from one tier to another)?

6) 6) Difference between Abstract classes and interface ?

7) 7) Does the abstract classes cantinas the implementation for methods ?

) 8)Can we create the object for abstract classes ? is it necessary to implement all the methods of abstract classes in derived class ?

9) 9) Can I implement multiple number of interfaces in a single class ?

10) What is meant by Partial Class ?

11 11) Difference between 2.0 and 3.5 ?

1 12) What are the new base class methods in .net 3.5 ?

1 13) What is meant by Object Instance Intialization in .net 3.5 ?

1 14) How can u handle the trouble shooting in ur project ? what is the use of N-unit ?

Did u use linq in ur project .. ?

15) “var” data type ? and tell me the extension methods ?

6) 16) Can we write the code for I have List and I have the table employee with employ id, employee name ,I fill the table in datasetset ,by using “ForEach” loop collect result row collection for list ?

Did u use Ajax in ur project ..

17) What is meant by Ajax ? use of Ajax ?

1 18) Can I have a Multiple Update panel in a webpage ?

1 19) In which Scenario we use in conditional mode in Update panel ?

2 20) What is the use of Script Manger and Proxy Script Manger ?

What are Ajax tools u used in ur project ?

21 21) Is it possible to invoke the modalpopup from code behind ?

2 22) What happens when page is refresh On Modalpopup ?

2 23) Page life cycle events ?

24) When the page is postback by an event handlers (like dropdownselectedindex, tnclickevent) When this event is executed before pageload or after pageload ?

5) 25) What is the “Auto Event Fired” What happened when it is true,false ?

2 26) What is the use of View State, if it is turned off what happened ?

2 27) Inprocess and out process Session memory ?

8 28) In Which Scenario we can use Outprocess session ?

2 29) Difference between Application variables and session variables , where we maintain application state ?

3 30) In forms Authantication , cookie, true or false represents ?

31 31) Difference between the cookies and sessions ?

3 32) Types of cache ? varyby param ? timeslide expiration ?

3 33) How can we set the time out of for datacaching ?

3 34) My storedprocedure returns 3 resultsset , does the datareader can handle ?

3 35) Difference between dataset and datareader ? which is light weighted ?

3 36) Where does the caching the data located ?

3 37) What is meant by Nullable type ?

3 38) Did use Jquey,Json ?

Pl Please share Your Interview Questions with me

My Mailid : nsubhash007@gmail.com

Accenture Dotnet Interview Questions

2010-05-19T00:34:00.001+05:30

Accenture Dotnet Interview Question , Bangalore April,2010, Shyam Kumar gone through Accenture

Explain ur current project ... role and responsibiltes

1. What are the interested areas that u worked in ur current project

2. Explain ASP.Net page LifeCycle.

3. What are the New features .net 3.5 ?

4. What is an interface

5. What are the Oops Concepts that are used in ur project..

6. What is abstract classes in which scenario u choose abstract clases over an interface.. ?

7. What is the use Static classes.. ?

8. How do u implement Encapusaltion in dotnet.. ?

9. Difference between gridview and datagrid.. /

10. If you enable the EnableViewState and disable all the controls What it happens.

11. How can we install dll explicitly in .Net.

12. Solve this

Int a=5;

String str ;

Str = a; // We have to convert the int into string.

Will the program gets executed or else whats the error u rgetting how can u clear it.

Does Object is Value type or reference type.
What is stack and Queue.Examples of these.

13. Use of garbage collector ?

14. CTS .. ?

15. Can we use insert statement into the cursor or we had only direct insert statement.

16. What is meant by View state

17. Is it possible to view the data in view state..

18. Diiference between Storedprocedure and function .. ?

19. Can we write.. an update statement in function ?

Hcl Dot net written test part 4

2010-05-05T16:50:00.001+05:30

Hcl Dotnet Written Test Part 4 ,Hyderabad May2nd 2010

1) sql query for replicate existing structure as new table without data

2) what is statemanagement?

3)what is CTS?

4)Difference between is and as operators?

5) array=1,1,2,2,2,3,4,4,23,23,45,45,50

o/p -->

1-2

2-3

3-1

4-2

23-2

45-2

50-1

Please send ur Interview Experinces to my Mail Id : nsubhash007@gmail.com