Sunday, June 3, 2012

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?

4 comments :

  1. For question 14 refer
    http://www.mathsisfun.com/pool_balls_solution.html
    http://en.wikipedia.org/wiki/Balance_puzzle

    ReplyDelete
  2. Hi subash actually I prepared some answers for the above questions that you have provided for the first section.

    1.what is the use of delegates?
    1.delegate are used to invoke the method.
    2.Using the delegate allows the user to encapsulate the method
    3.Improves the performance

    2.Features of c# 3.5?
    Ans

    a)Implicit Variables

    var a=10;

    by declaring the implicit variable it can determine the datatype during the compile time

    b)Properties

    In properties you dont need to give the complete syntax as you did earlier.you can see the below format for ex

    public string UserName { get; set; }

    c)Usage of lambda expression,Linq

    d)Ajax


    ReplyDelete
  3. 3.)StateManagement Concept in Asp.net?

    The statemanagement is the process by which you maintain the state over multiple requests across the same or different Pages.There are two types of state management client Side-cache,view state,cookies,query string.etc and Server side-Session and application object

    4.)In which event you can change the content of the Page?

    Page_PreInit

    5.) Explain about Page Life cycle?

    1.Page_PreInit

    2.Load_ViewState

    3.Load_PostData

    4.Page_Load

    5.Raise_PostDatachanged event

    6.Raise_PostBack Event

    7.Page_Prerender

    8.Save_ViewState

    9.Page_Render

    10.Page_unload

    6.In which Page_State the PostBack occurs?

    Raise_PostBack Event

    7.How do you called the garbage collection explicitly?

    gc.collect();

    8.What is GAC?

    Global assembly cache.It is the public folder available in the root directory of your system where all the shared dll(assembly) will be available and these dll's can be used by all the application in your system.The Assembly are refered using the strong names in the GAC folder

    9.What is CTS?
    Common Type System.CTS has many types which can be used by different .Net languages.IF you use CTS then two objects of two different .NEt languages can interact easily.

    10.Difference between stored procedure and function?

    stored procedure

    1. They can return zero values as well as n number of values.
    2.They can have input and output parameters
    3.They cannot be used within SQL statements
    4.They can act individually
    5.The temporary tables can be created using the stored procedure

    Function

    1.They can return only single value

    2.They can have only input parameters

    3.They can be used within the select as well as update statements

    4.They cannot act individually

    5.There cannot be temporary tables with the function

    11.Can function return table valued parameters?

    Yes function can return table valued parameters

    12.Difference between local temporary table and global temporary table?

    Local temporary table:
    1.Denoted by #
    2.Available only for the current connection

    Global temporary table:
    1.Denoted by ##
    2.Availble for all the connection and sessions

    13.What are the type of log files available in SQL server?

    1.shared log file
    2.Session log file
    3.Stand-alone log file

    14.What is a trigger?
    Trriger are the database object which are similar to stored procedures that executes in response to some actions that occured in database environment.

    15.What is the use of instead-of-trigger?
    They the allow the devloper to divert the database engine to do something different than what they are trying to do.

    16.What is the use of nested transactions?
    Transaction is the process of combining two or more events.Sql server allows you to nest transaction.By setting this a new transaction can start even though the previous one is not complete



    ReplyDelete
  4. I constantly emailed this web site post page to all my friends, as if like to read it next my contacts will too.

    ReplyDelete