మహా నేత

మన గుండెల్లో గూడుకట్టుకున్న వైయెస్ ను ఈ తోలి వర్దంతి మల్లి మొలకేత్తిస్తుంది
జ్ఞాపకాల గర్బం నుంచి వైయెస్
ఆశయాలకు ఊపిరిపోస్తుంది
ఈ మహానేత తోలి వర్దంతికి ఘన నివాళి ని అర్పిద్దాం!
ప్రవీణ

.Net Remoting with Best Example & Explanations

http://msdn.microsoft.com/en-us/library/kwdt6w2k(VS.71).aspx
http://www.codeproject.com/KB/IP/Net_Remoting.aspx
http://www.codeproject.com/KB/IP/processactivator.aspx
http://j-integra.intrinsyc.com/support/kb/Article.aspx?id=183204
http://www.c-sharpcorner.com/UploadFile/nagryum/Appdomain07102007081415AM/Appdomain.aspx
http://www.dotnetuncle.com/Difference/42_web_service_remoting.aspx
http://www.developer.com/net/net/article.php/2201701/NET-Remoting-Versus-Web-Services.htm

Asp.Net page life cycle

http://msdn.microsoft.com/en-us/library/ms178472.aspx

page life cycle

http://spazzarama.files.wordpress.com/2009/02/aspnet_page-control-life-cycle.jpg

Telephonic Interview

1. What is ref, Out parms?
A.
2. What is app domain?
3. What is constant, Read only?
4. What is static constructor?
5. What is static object?
6. How u will consume web services?
7. What is use of Ajax?
8. How to create usercontrol dynamically?
A. 1.First , you need to add a directive on webform telling the webform that you are going to load the usercontrol dynamically.
2.load the actual control in the webform. You can load the control anywhere in the form. A good place will be the Page_Init event.(by using page.LoadControl()), by creating instance of that control.
3.Add the instance control name.

More Detail....

3rd Interview(TCS)

1. What is view_State?
A. The View_State is a client side state management. which maintain or stores the information of page controles with unique ID in encrypted formate.When the page is processed, the current state of the page and controls is hashed into a string and saved in the page as a hidden field, or multiple hidden fields

2.Write The query for fallowing table salary field null values filled with 10000, with out using Update?
Emp_ID Salary
A 5000
B Null
C 3000
D Null
E Null
A.

3.What is serialization?
A.Serialization is a process of converting an object into a stream of data so that it can be is easily transmittable over the network or can be continued in a persistent storage location. This storage location can be a physical file, database or ASP.NET Cache.
Serialization can be defined as the process of storing the state of an object instance to a storage medium. During this process, the public and private fields of the object and the name of the class, including the assembly containing the class, is converted to a stream of bytes, which is then written to a data stream. When the object is subsequently deserialized, an exact clone of the original object is created.

4. what advantages of stored procedures?
A. 1.Execution plan retention and reuse
2.Query auto-parameterization
3.Encapsulation of business rules and policies
4.Application modularization
5.Sharing of application logic between applications
6.Access to database objects that is both secure and uniform
7.Consistent, safe data modification
8.Network bandwidth conservation
9.Support for automatic execution at system start-up
10.Enhanced hardware and software capabilities
11.Improved security
12.Reduced development cost and increased reliability
13.Centralized security, administration, and maintenance for common routines

5.What type of Execeptions used in ur application?
A.An exception is an error condition or unexpected behavior encountered by an executing program during runtime.
System.OutOfMemoryException
System.NullReferenceException
Syste.InvalidCastException
Syste.ArrayTypeMismatchException
System.IndexOutOfRangeException
System.ArithmeticException
System.DevideByZeroException
System.OverFlowException
Sql Exception.

6. Where you will set your connection string?How to Access through your page?
A. IN Web.config File, we can access this conn through configuration manager.

7.What is ajax?
A.Ajax (shorthand for asynchronous JavaScript and XML[1]) is a group of interrelated web development techniques used on the client-side to create interactive web applications. With Ajax, web applications can retrieve data from the server asynchronously in the background without interfering with the display and behavior of the existing page.

7.What is a view?
A A view is a virtual table contails columns of one or more tables. a view contains logical information of physical tables.

8.WHAT IS TRIGGER?
A. Creates a DML, DDL, or logon trigger. A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected.

DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations. Logon triggers fire in response to the LOGON event that is raised when a user sessions is being established. Triggers can be created directly from Transact-SQL statements or from methods of assemblies that are created in the Microsoft .NET Framework common language runtime (CLR) and uploaded to an instance of SQL Server. SQL Server allows for creating multiple triggers for any specific statement.
Trigger

9.What is indexing?How many indexes we can create on a table?if we have more indexes it will degrade the performance of a table?
A.An index is a database object created and maintained by DBMS.An index is an on-disk structure associated with a table or views that speed retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view”. These keys are stored in a structure (B-tree) that enables SQL Server to find the row or rows associated with the key values quickly and efficiently.”
SQL Server has two major types of indexes:

1.Clustered
2.Non-Clustered
A table can have only one clustered index
and 249 non clustered index.
The performance: If a table has too many indexes associated with it, the updates or inserts or deletes on it would slow down.

10.What is paging in gridview?How to set first 20 records in grid view?What are the properties of gridview>
A. Paging is the property of gridview, which allows you to navigate the next records.
See link Grid view Properties
In page size property of grid view we will set

11.How to set the check Box control in Gridview?
A.

12. What is cookies?
A.Most browsers support cookies of up to 4096 bytes.
A Cookie is a small text file that the browser creates and stores on the hard drive of your machine. Cookie is just one or more pieces of information stored as text strings. A Web server sends you a cookie and the browser stores it. The browser then returns the cookie to the server the next time the page is referenced.
Creating cookies with ASP.NET is simple and straight forward. The System.Web namespace offers a class called HttpCookie to create cookies

2nd Interview

In this interview mostly interviewer asked about early satages of project implimentation
Tell me About your-self?
1.What is catching?where caching data will store?
A.It is a way to store the frequently used data into the server memory which can be retrieved very quickly. And so provides both scalability and performance. For example if user is required to fetch the same data from database frequently then the resultant data can be stored into the server memory and later retrieved in very less time (better performance). And the same time the application can serve more page request in the same time (scalability).At Server side

2.What is polymorphism, What are the types?
A. Refer First Interview Questions.

3.When Team Leader Given a task What steps You fallow to do do that task?
A.

4.When i Clicked a button in a page, How your event process will happen in your code(MVC-Model-View-Controller)?
A.MVC Framework

5.In database design what steps you will take to better performance?
A.Query Optimization. See below Link
How to do

6.What are the Collection Objects Used in ur Project?
A.The .NET Framework provides specialized classes for data storage and retrieval. These classes provide support for stacks, queues, lists, and hash tables.
See below link
Collections

7.Code Optimization?
A. program optimization or software optimization is the process of modifying a software system to make some aspect of it work more efficiently or use fewer resources.[1] In general, a computer program may be optimized so that it executes more rapidly, or is capable of operating with less memory storage or other resources, or draw less power.

8.What is Temporary table in sql server?
A.In a stored procedure, you often have a need for storing a set of data within the procedure, without necessarily needing that data to persist beyond the scope of the procedure. If you actually need a table structure, there are basically four ways you can "store" this data: local temporary tables (#table_name), global temporary tables (##table_name), permanent tables (table_name), and table variables (@table_name).
More...?Temporary Table

9.Do you have testing Team?, How they will deliver project fails to you?
A.

10.What are the parameters of connection string?
A. Server, Intial catalog, DataBase, User id , Password, Integrated Security.

11.do you used hash tables?
A.Dictionaries or Hash Tables also let you store any type of object but you store them in key/value pairs.A key cannot be a null reference (Nothing in Visual Basic), but a value can be.
//
// Instantiate a hashtable.
//
Hashtable hshData = new Hashtable();
//
// Add key/value pairs to the hashtable.
//
for (int i = 0; i < 10; i++)
{
hshData.Add(i, "Item" + i.ToString());
}
//
// See if we have items in the hashtable.
// Get the first item by specifying its key.
//

My First Interview Questions

1. Explain about ASP.NET Page Life Cycle?
Ans:When an ASP.NET page runs, the page goes through a life cycle in which it performs a series of processing steps. These include initialization, instantiating controls, restoring and maintaining state, running event handler code, and rendering.
2. What is Ajax
3. We have to do 2 things Before using ajax What are they
4. What is interface?
Ans: Inheritance enables you to create new classes that reuse, extend, and modify the behavior that is defined in other classes. The class whose members are inherited is called the base class, and the class that inherits those members is called the derived class.
5. What is oops
6. What is encapsulation
7. What is Stored Procedure
8. What is command for Knowing List of tables in sql server
Ans: sp_tables(which display all tables and their associated constraints information)
select * from sys.Tables(which display in more detail with how many colomuns in the table , when it was created..etc)
9. What is command for opening stored procedure query
10.Tell me about ur projects
11.What data controles used for data display
12.What is diff b/w GridView and FormView
13.The fallowing program will execute?
interface intf1
{
private void meth();
}
14.What is inheritance?
15.What is Polymorphism?
Ans.Poly means many and morph means form. Thus, polymorphism refers to being able to use many forms of a type without regard to the details.
Types of polymorphism
1.Compile-time polymorphism(Static polymorphism/Overloading/Early Binding)
Method Overloading is using same method name with different parameters
Ex:
public class AddingNumbers
{
public int Add(int a, int b)
{
return a+b;
}

public int Add(int a, int b, int c)
{
return a+b+c;
}

}

2.Run-time polymorphism*Dynamic polymorphism/Overriding/Late Binding)
Runtime time polymorphism is done using inheritance and virtual functions. When overriding a method, you change the behavior of the method for the derived class. Overloading a method simply involves having another method with the same prototype.

EX:
Class Test
{
Public virtual void show()
{
Console.WriteLine(“From base class show method”);
}
}
Public Class DynamicPolyDemo : Test
{
Public override void show()
{
Console.WriteLine(“From Derived Class show method”);
}
Public static void main(String args[])
{
DynamicPolyDemo dpd=new DynamicPolyDemo();
Dpd.show();

}
}