Friday, June 4, 2010

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.
//

No comments:

Post a Comment