Some Interview Questions about C# ASP OOP asked in one level 5 company-2

1.    What are OOPs concepts?

2.    What is Polymorphism?

3.    What is Runtime Polymorphism?

4.    What is Overloading and Overriding?

5.    Can’t we override without having Virtual keyword for base class method?

6.    Is overloading method change the body?

7.    Is it really required to implement all the method of an Interface in child class?

8.    How can we create object for Interface?

9.    How can we prevent overriding an abstract method?

10.  How can we write a abstract method in a non abstract class?

11.  How can we create object for a abstract class?

12.  Explain the real time scenario, when to use abstract class?

13.  What are the Access modifiers we have in C#?

14.  What is Enum? Have you used. Why and How?

15.  How to handle exceptions in C#?

16.  Can we have multiple Catch blocks?

17.  If one catches the next catch will be executed or not?

18.  Can we have multiple Web.config files?

19.  If yes which one executes first?

20.  Is it possible to have a vb.net class file in C# project?

21.  How they communicate?

22.  What is Viewstate?

23.  Can we pass data in Viewstate object to next page?

24.  In which page event you will get Viewstate data?

25.  Where the Viewstate data saves?

26.  What is Session?

27.  Where the Session data saves?

28.  How the server knows that a particular user session has been created. Because Session is Server side.

29.  What are the types of session modes?

30.  What is cookie less session? What happens if browser stops cookies?

31.  Have you ever used Query Strings what are limitations of Query Strings?

32.  Do you know WCF?

33.  Do you know Web Services?

34.  Explain Page life cycle?

35.  In which event will all the controls loaded?

36.  Where will check about post back page?

37.  What is the last page life cycle event?

38.  What happens in that?

39.  What is the use of Global.asax file?

40.  How can you display a common error page when an error occurs?

41.  What is Hash table?

42.  What is difference between Hash table and Dictionary

43.  Can’t we hold any type of data in Dictionary?

44.  What is a Heap?

45.  What is Value type and Reference type?

46.  Give me two examples of Value type and Reference type?

47.  Why to use stored procedures over inline queries?

48.  What is a View?

49.  What is temporary table?

50.  Can we create index on temporary table?

51.  What is clustered and non-clustered index?

52.  What is the deference between Primary key and Unique key?

53.  When you apply Unique on a table which index will be created?

54.  How to get a current inserted record id after executing stored procedure?

55.  Can we get XML script from stored procedures?

56.  Write the logic to get row number and duplicate row from table?

57.  What is the use of Having clause?

58.  Can we use Where and Having clause in same query?

59.  Explain about all joins?

60.  What result will get if right hand side table not having matching data?

61.  What is cross join?

62.  If I have two tables with 10 records in each, how many I get in resultant cross join?

63.  What is Equiv. join?

Employess

EmpId	Name	Sal	DeptId	MgrId
1	Ram	10000	1	4
2	Srinu	4000	2	4
3	Ravi	20000	3	2
4	Vinod	2000	1	3

Dept

DeptId	DeptName	Location
1	Dept1	HYD
2	Dept2	HYD
3	Dept3	Bangalore

64.  Display Employee name, Salarry and location whose location belongs to HYD

65.  Display Employees name, Salary, location and employee related manager whose location is HYD

66.  Display Employee count whose location is HYD and having salary >4000

67.  What is the difference between Data set and Data Reader?. Which one is preferable and Why?

68.  What is disconnected architecture?

69.  What happens if I not close a connection in connected architecture?

70.  Write a script of using ado objects for “Select * from Employees”. Which one you use Datareader or Data set.

71.  If use data reader how cans you bind data to data grid?

72.  What is event bubbling?

73.  How the parents know that child invoked an event?

74.  How to update a 5^th cell in a data grid?

75.  .What is the types of Authentications are there and which one is preferred mostly?

76.  How can we stop Sessions?

77.  Which file is needed in all type of web application to run?