20 July 2013

Real life Interview questions

Following are the list of interview questions faced by me and my friends. Please feel free to share your own as comments and i will publish them...

  • Sukesh Marla(2.5 yrs of experience - Shawman Softwares)
    .net Interview questions part1
    1)Which will you prefer Server.Transfer or Response.Redirect and Why?
    2)How will You Define Generic in a single sentence?
    3)Whats The Difference between ControlState and ViewState
    4)What is Event bubbling
  • Chaitali Ladhe(G5 Web Services)
    .Net Interview Questions.
    1) What is Method overloading and method overriding?
    2) What is Boxing and Unboxing? Explain with example.
    3) Explain Object oriented concepts in detail with example.
    4) Program to swap 2 numbers without using temporary variable..
  • Sai(2.5yrs of exp - ShawMan Development)
    CSS Interview questions -
    1. What is inheritance in CSS?
    2. What is overriding in CSS?
    3. When we use "important" keyword in CSS?
    4. Difference between block & unblock elements?
    5. What is position?
    6. what is shothand properties?
    7. drawbacks of table?
    8. what is em?
    9. advantage of extenal CSS?
    10.advantage of Div?
  • 1) What are types of polymorphism
    2) What is the difference between function, stored procedures, and views
    3) How do you migrate data from 2000 to 2008
    4) What is the difference between .net framework 2.0 and 3.5
    5) Give an code for LINQ
    6) Give full form of LINQ
    7) What are types of triggers
    8) What is sql injection
    9) How to do bulk insert in database by reading from csv file
    10) Can we have multiple catch statements for try
    If yes then what is the sequence in which the catch statements are excuted
    11) What is use of views
    12) Difference between where and on
    13) How to make the thread sleep for infinite duration
    14) What is remoting
    15) What is serialization and its types
    16) Can we write this
    Select viewname
  • 17) What is the difference between global variables and system variables
    18) How to use system variables as Local Variables
    19) What is the class used for generics
    20) What are components of ado.net
    21) What are types of caching
    22) What are types of indexes
    23) Page Life cycle
    24) VSS -> Merging and Branching
    25) What are types of triggers
    26) How do we access gridview inside gridview
    27) How can we do optimization in sql for queries
    28) What is satellite assembly
    29) What is localization and globalization
    30) What are access specifiers
    31) How do we restrict the class to be inherited
    32) What is class, object
  • 33) What are new fetures in sql 2005
    34) What is hash table
    35) What is stack and queue
    36) Difference between structure and class
    37) Is assembly a logical or physical unit
    38) Which of the following is not related to Dataset
    a) Datarow b) Datacolumn c) Dataview d) Datareader
    39) Which is faster updatpanel or callback? Why?
    40) How do we implement callback
    41) In javascript, what is undefined and null
    42) Do events have return types
    43) What are types of Indexes
    44) Port number of HTTP
    45) Is ftp a protocol
    46) Difference between stored procedures and functions
    47) What is a class
    48) Can garbage collector called? What period of time?
    49) What is assembly?
    50) What is https?
    51) For whose the performance is optimal. Considering viewstate(grid, datalist, or repeater)
    52) String and stringbuilder class
  • 1. How to force to call Garbage collector?
    2. What is the diff between truncate and delete?
    3. How many types of commands in sql server?
    4. What DDL and DML?
    5. Is class reference type or value type?
    6. What GC.Collect ?
    7. Is Enum reference type or value type?
    8. Does the performance of viewstate vary according to user control?
    9. Which user control(Reader, DataGrid, DataList) provide less performace?
    10. Can abstract class have constructor?
    11. Can we explicitly specify return type for constructor of abstract class?
    12. How to implement read only property?
    13. What is the diff between abstract class and interface?
    14. Can we assign diff access modifire for set and get of the same property?
  • 15. Can private variables be inherited?
    16. What are benefits of normalization?
    17. How many types of session in asp.net?
    18. Do events have return type?
    19. Which type of session have Session_End event?
    20. What is index in sql server?
    21. Can we have only get method in property?
    22. How to define a property?
    23. What is the diff between convert.tostring() and .tostring()?
    24. What is normalization? What is 1st nf, 2nd nf and 3rd nf?
    25. What is multithreading?
    26. What is the diff between ArrayList and List?
  • 1.What is verification and validation?
    2.What is the difference in testing a CLENT-SERVER application and a WEB application ?
    3.What are the typical problems in web testing ?
    4.How to test Browser compatibility testing?
    5.What is your approach or how do you start Testing an Webapplication?
    6.During the passward field testing. What sould be the focus (give answer in one word).
    7.From the testability point of view what is the difference between client/server testing and web testing?
  • 1.What is verification and validation?
    2.What is the difference in testing a CLENT-SERVER application and a WEB application ?
    3.What are the typical problems in web testing ?
  • please put ur name with experience first..
    also try to separate the questions in group such as .net interview questions and sooo
  • 1. What is process?
    2. What is thread?
    3. Difference between process and thread?
    4. Difference between primary key and unique key?
    5 What is boxing and unboxing?
    6 What is difference between delete and truncate in SQL?
    7 What is CTS?
    8 What is Assembly? Types of Assembly ? And Difference between that types?
    9 What is GAC?
    10 What is difference between Data reader and Data set?
    11 What is CSS? Types of CSS?
    12 What is JQuery and use?
    13 How many types of validation controls in .Net? Expain each?
  • Deepali Pujari(1.4yrs of exp -I2eye Interactive)

    1.Explain ASP.NET Page Life Cycle?
    2.What is Session and explain the difference between session and cookies in asp.net?
    3.advantage of ajax in .net?
    4.difference between ajax and javascript?
    5.How to implement multiple inheritance in .NET?
    6.what is interface in .net explain with real world example?
    7.Difference between interface and abstract class in .net?
    8.what is polymorphism in .net explain with one example?
    9.difference between datalist and gridview in asp.net?
    10.Types of validation controls in asp.net explain with examples?
    11.A textbox which allows only numerical values then which validation control we will use?
    12.what is dataset in ado.net?
    13.What is disconnected and connected architecture in dot net?
    14.difference between dataset and datareader?
    15.what is sqlcommand and what are the methods of sqlcommand ?
    16.What is Connection Pooling in ASP.NET ?
  • Sukesh Marla(2.5 yrs of exp-shawman softwares)

    1.What are the types of triggers?
    2.Advantages of triggers?
    3.Why we use multiple triggers?
    4.How to set the order for trigger in case of multiple triggers?
    5.What type of process you follow in ur current organization?
    6.what are the new features in sql 2005?
    7.There will be one table TblEmployee(EmployeeId,EmployeeName)
    your work is to show the entire table in grid which contain 3 columns-SrNo EmpId EmpName
    How u will achieve this?
    8.What are the types of Temporary Tables in sql?
    9.When to use Temp table and when Table Variable?
    10.How to make class non inheritable in c#
  • Kanchan Nemade(2.2 yrs of exp-shawman softwares)
    1. will the following program compile?
    public partial class Default3
    protected void Page_Load(object sender, EventArgs e)

    catch (Exception ex)
    catch (NotFiniteNumberException ex1)


    2. Will the following program complie?

    public partial class Parent:Child
    protected void Page_Load(object sender, EventArgs e)



    public interface InterfaceChild

    int Square (int)
    3. What are implicit objects in C#?
    4. What is Serialization?
    5. What is triggers?
    6. Do events have return type?
    7. OOPS features?
    8. how to prevent a class to be inherited from another class?
  • 1)If we have a set of primary keys in a single table... what are they called?

    2)How can we Sort Arrays in C# ?

    3)What is the use of Stored procedures?

    4)Diff. Between VB and .Net?

    5)SQL Query to display 2nd largest salary of an employee ?

    6)What is the use of CTS in .Net?

    7)Write a C Program to display prime numbers from 1-100

    8)If we have both internal and external stylesheet defined on a page, which one will the browser use?
  • 1)Page lifecycle
    2)what is view state
    3)what is session & types
    4)what is better in session performance wise - out proc or in proc
    5)types of state management
    6)what is caching & types
    7)what is handler
    8)what is Event bubbling
    9)if two scriptmanager added in one page den ??
    10)How to create runtime textbox using javascript
    11)what is ajax
    12)what u have done in javascript
    13)what is ado.net architecture
    14)ADO .net syntax to fill datatable
    15)Diff between store procedure & Function
    16)What is web service
    17)How to consume web service
    18)what is abstract class
  • Pradeep V Kumbhar(1.2 yrs exp in Shawman Software)
    1.If we using asp.net 3.5 then which version of C# we used?
    2.What is advantages of 3-tier architecture?
  • Ashish Aphale(Fresher)

    1.access modifiers in VB.net(5 type)
    2.why we cannot use multiple inheritance in both C# & Java
    3.what are the stored procedures?
    4.difference between unique & primery key
    5.what is cross join
    6.different objects in ADO.net
    7.explain the assemblies,meta data in .Net
    8.page life cycle in ASP.net
    9.use of connection string
  • 1) Vb.net/C#.net/Asp.net: How do you get and set a connection string in app.config & web.config files?
    2) SQL: In sql, how will you fetch the last inserted identity value for a table?
    3) SQL: Select the 2nd highest salary from a table without using Max or Top.
  • Pradeep V Kumbhar (1.4 yrs of exp-Shawman Software)
    1.What is partial class?
    2.What is server side objects?
    3.State Management techniques?
    4.What is web service?
    5.What is interface? What is access specifier of interface method?
    6.How to Ajax.dll and Ajax.ToolKitdll to project?
    7.How to do transaction in sql?
    8.What is OUT parameter in sql?
    9.How to pass parameter from .net to sql-stored procedure?
    10.What happen if we write command.ExcuteNonQuery instead of command.ExcuteReader while retriving data from database?
    11.What is GET and POST method?
    12.What is compulsary attribute of asp control?
    13.What is runat="server"?
    14.What is cookie size?
    15.How to call method in default.aspx.cs page from default.aspx-javascript using AJAX?
    16.Can we call function of Database from .net?
    17.How many Web.config in project?
    18.In ADO.NET what is connected and disconnected architechture?
    19.In HTML why controls like button etc.. is always in form tag?
    20.There is two table
    1.Product and column name=pid(primary key),productname
    2.Order and column name= oid(primary key),pid(foreign key),quantity

    write a sql query to get quantity using join.

    21.What is overloading and overriding?
    22.Which is first directive in .aspx page?
    23.How to call any function from stored procedure?
  • Ashwin Araokar (3.2 Years of Exp)

    1. Types of index and explain them.
    2. In which scenario index should not be used.
    3. What are triggers..have u used it practically..y did choose to use a trigger and not implement the logic in front end..
    4. what are stored proc...where have u used it??
    5. query to get employee name and corresponding manager name...data present in a single table...
    6. query to get emp name (from emp table) and corresponding dept name (from dept table)
    7. what is inheritance...in which scenario have u used it practically
    8. how would u stop a class from being inherited
    9. what is method overriding and where have u used it
    10. wot r the ways to retrieve data from backend.
    11. wot is dataset, datareader, dataadapter
    12. how wud u exec a stored proc from frnt end and hw wud u pass parameters to it
    13. in a datagrid if 2 rows are to be updated and if error comes while updating second row then the both the rows shouldnt be updated..how wud u achieve dis..
    14. wot is a transaction..commit and rollback transaction to be explained
    15. explain mvc
    16. if a transaction is to be rolled back where that piece of code would be written...in the model or the controller..
    17. how to define a transaction....
  • Saiprasad Sherlekar (3 yes Experience)
    1.Try to explain you project in short
    2.Primary Key Vs Unque Key
    3.What is DataReader?
    3.What are the methods of SQLCommand Class
    4.Server.Trasnfer Vs Response.Redirect
    5.What is SqlCommand.ExecuteMomQuery() method,Can we use it for Select Query
    6.What are DDL an DML Statements in sql
    7.Store procedures Vs Function
    8.char vs varchar
    9.What are triggers in sql?
    10.varchar vs nvarchar
    11.ADO,net archnitecture
    12.Providers in .net
    13.what is native provider
    14.Can we connect to sql using OLEDB
    15.Temporary table vs Table variable
    16.local vs global temporary table
    18.Why we cany write DML statement in function??
    19.Types of sql Function.
    20.How to write Table Valued Function
    21.Pass by Value VS Pass by Reference
    22.Clustered Vs Non Clustered Index
    23.PK Vs Foreign Key
    24.How to write transactions in Sql
    25.What is Atomicity in ACID
  • Sukesh Marla (3 yrs Experienced)
    1.What is nested stored procedure?
    2.What is mean by nested cursors?
    3.Temp table vs Table variable
    4.How to optimize a sql query?

    5.Explain The process in Your Company?
    6.Type Of providers in .net
    7. Connected Vs Disconnected architecture in .net
    8.What are the Methods of SqlCommand Class
    9.When Datareader will be preferred?
    10.How to Iterate through sql resultset,without using cursors?
    11.Types of Sql Functions
    12.Sql Functions Vs Stored Procedures
    13.Truncate Vs Delete
    14.PK VS UK
    15.If u have 3 interfaces I1,I2,I3 all of which contain 2 methds
    class is derived frm all 3 of them,
    i Override 2 from I1,
    1 from I2
    and 2 from I3
    will it work?
    16.We have abstract class ,and class will be derived form that without Overriding the abstract method present in abstract class,
    will it compile?
    17.Once upon a time developer developed a class,with a method say M1
    now i have derived a class from that so that i can override that method but unfortunately Prev Developer forget to declare it as virtual
    now what i can do,if i want a fresh copy of that method according to my convenience?
  • Pradeep V Kumbhar (1.5 yrs of exp-Shawman Software)

    1.Tell me about youe self?
    2.Tell me about projects that you worked on?
    3.What is sealed in c#?Why it is used?
    4.What is difference between Abstract class and Interface?
    5.In your project which tier architecture used?
    6.How front end value is passed to database through that tier-architecture?
    7.Which is Session management techniques?
    8.What is view state?Can we see view state value of password textbox?How?
    9.What is Left join?
    10.What is Normalization?
    11.What is function?
    12.In stored procedure suppose we calling one function that function inserting value in one table? Is this work?
    13.What is Repetar and what about its performance than other Data Controls?
    14.Tell me code that bind dataset to DataGridView?
    15.What is Dataset?
    16.What is Transaction in .NET not in sql?
    17.Can we create object of abstract class?
    18.Why you use abstract class in project?
    19.What type of session used in your project?
    20.Can you know about Design pattern in .NET?
    21.In Static class is any there any non-static methods?
    22.How can we call static methods?
    22.How can we call non-static methods?
    23.Which ASP.NET features used in project?LINQ etc?
    24.What is LINQ?
    25.Can we do linq on list objects?
    26.Can we do linq on DataSet?
    27.What is constant and readonly variables?
    28.What is String and StringBuilder?
    29.What is IsPostBack?
    30.What is Server.Transfer and Response.Redirect?
  • Dipal Shah (3+ Experience - Etouch System)
    1. If you just write “ Hello World” in a page without Doctype, html, head, will this page run in a browser>
    2. If you write Hello & World in different span, how it will look in browser?
    3. If you write Hello & World in different div, how it will look in browser?
    4. If there are many pages in your website, your boss just asks you to remove footer in 2 minutes. How you will manage?
    5. What is the difference between Inline & Block Element?
    6. What are the different values for Position?
    7. What are the different values for Display?
  • Above one posted by Dipal shah is for HTML Developer.
    Thanks for participating dipal, Please make sure to put post u have been applied for along with Experience, else will be difficult for beginners to identify.
  • Can anyone please let me know how to call Session_End get and session value when user closes the browser or navigate to previous page?
  • Which opp's property come when we add page in .net(Default.aspx)

    1. 1. Is it possible to declare interface as private? If so, what are the conditions to be checked and any real time scenario for this.
      2. If we declare a constructor with string as parameter, is it necessary to define the default constructor or .Net Compiler will define that
      3. String Comparison.Does it compare the strings or the location (ie reference)
      4. Globalization & Localization
      5. If I don't want my class to be inherited, what can we do other than sealed class.
      5. use of GAC other than versioning, strong name concepts
      6. difference between Copy and Clone in C# in related to memory allocation
      7. Difference between Critical Section and Mutex in multithreading
      8. Transaction rules in SQL server
      9. Difference between Debug & Release modes
      10. What are the ways to end the windows application other than exit()
      11. What are the possible access modifiers for properties and for set & get modes

    2. 1. Why do we need contract in WCF.
      2 What is ViewState
      3 What is Normalisation
      4 Types of Normalisation
      5 what Event Bubbling
      6 difference between Cursor and While loop in Sql.
      7 Difrerence between Having and Whare
      8 Delete V/S Truncate
      9 Interface V/S Abstract Class
      10. How to decide when to Interface and when to use Abstract Class.
      11 String V/S String Builder.
      12 Delegate VS Events
      13 Difference between Sql Function and Store Procedure
      14 Dynamic Polymophism ? Example ?
      15 Difference Web Service and WCF
      16 What is end point in WCF
      17 What is Contract in WCF
      18 Server.Transfer V/s Response.Redirect
      19 Can WCF services be created without Interface?
      20 Can session be accessed in JavaScrpit If yes then how?
      21 Does browser directly send request to IIS server?
      22 How does browser get to know that request is for which server.
      23 How to restrict user to access particular page using direct url?
      24 Authentication Vs Authorisation.
      25 What is Constructor and distructor ?
      26 What is Const(constant) type
      27 Disfference between Custom Control and User Control
      28 What is Custom Data Type
      26 What is the actual Use of Constructor and distructor? Examples?
      27 Types of Protocol in WCF?
      28 How many types of binding is there in WCF ?
      29 What is the best/main reason to use WCF service and not any other services. Reason because of which no other services can replace the WCF ?


    Your comments, Feedbacks and Suggestions are very much valuable to me :)

    Things are upgraded

    My Dear readers, I am really thankful for being supportive all these years. This site was the first blog site I ever created in my life...