Saturday, July 16, 2011

Accenture Dotnet Interview Questions


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



2 comments :

  1. Hi Subash good work, please update it regularly.
    for 9:

    Regex Empid_Empname= new Regex(@"^\d+$");
    if(Empid_Empname.Matches(textbox1.text)
    {
    call empid
    //select * from emp_details where emp_id
    }else
    {
    call empname
    //select * from emp_details where empname
    }

    ReplyDelete
    Replies
    1. for 17 question: It is possible to identify the which control causes post bak

      page.Request.Params.Get("__EVENTTARGET");

      Delete