Saturday, April 9, 2011

Interview Qns(.Net, SQL) Part - 3

Why do we use Stored Procedures ?
Does change in parameters affect the execution plan ?
Suppose Table name is a parameter, Does that affect the execution plan ?
What is Garbage collection ?
How does CLR know that an object is no longer in use and can be disposed ?
Suppose I create 10 objects, but uses only 3 of them , Does CLR automatically dispose the other 7 objects ?
How do u trobleshooot performance issue for a page in your ASP.NET application?
What are different Session State modes in ASP.NET ? What are advantages and disadvantages of each ? When do we chose each modes ?
I have 10 pages in my application. I need 5 pages to be available to all users. But other 5 pages should be available to users with specific previlage only. How can I achieve this ?

Interview Qns(.Net, SQL) Part - 2

Why does an exception happens in above scenario ? How can we avoid that ?
What is identity Impersonization in ASP.NET ?
How do we specify a start page for our ASP.NET applicartion ?
Suppose there are multiple versions of .NET installed on server, How do we configure our application to use a specific version ?
What is the use of ASP.NET_RegIIS tool ?
What is application pool. What is its use ?
Which is the base class of all pages in an ASP.NET application ?
What are web services ? Why do we need them ?
Can u write an example of inheritence ?
When I create an object of derived class, In what order will the constructors be invoked ?
Suppose I want a parameterized constructor for base class to be invoked when I create an object of derived class, How can I acieve this ?
I need to have a property in a base class and derived class. I need base class property to be get and set, but derived class property should be get only. How can I achieve this ?
What are different access modifiers ?
What is the use of 'internal' keyword ?
What will be the default access modifier for an Interface ?
What are static classes ?
When is static class objects created in memory ?
Can we specify access modifiers for a static class ?
Will this code show a compile error ?

Static class ClassA
{
private int a ;
public static void Func()
{
int b = a;
}
}
How can we fix the error ?
What is method overloading ?
How all can we achieve method overloading ? What abt diffrence In order only ? Ie) (int, string) and (string, int) ?
Can we achieve overloading by changing return type ?
Can u write a function which accepts a string as argument and return its alphabet compliment ( (ie) "abc" returns "zyx")
What is xmlHTTP object ? What is its use ?
Suppose I have a Gridview with employee details. How can I achieve edit functionality completely using Javascript ? Ie) on clicking edit, a popup shoud come with editable details.
After editing and saving, it should refresh parent grid data.
In javascript, How can we access parent page ? How can we refresh data in parent page ?
Suppose I have a Dataset with full employeee details. I need to get the list of employee names as a string array. How can I acieve this ?
Can u write a LINQ to Dataset query to achieve the above ?
Have u implemented any design patterns in your projects ? Can u explain details of implementation ?
Can u explain factory pattern ? Can u identify a potential scenario where factory pattern can be used ?

Thursday, April 7, 2011

Interview Qns(.Net, SQL) Part - 1

What is .NET framework ?
Why is CLS required ?
What is MSIL? Why is it required ?
What happens if .NET converts our code directly into machine code ?
What is the use of Global.asax file? Is it mandatory ?
What is Application and Session variables? When do we use them ?
How is Session State managed in ASP.NET ?
How do ASP.NET identify each user for his session ?
Where is Session data stored ?
What are different Session State modes in ASP.NET ? When do we use each ?
What type of data can be stored in Session ?
Why is it required that data stored in Session should be serializable ?
Is it applicable for InProc model ?
What is diff b/n Session["UserName"].ToString() and Convert.ToString(Session["UserName"])
How can I check whether Session["UserID"] can be succesfully converted to Int or not ?
What is the advantage of TryParse() ? Can u write an example of TryParse() syntax ?
What is cookies ? Where is it stored ?
What kind of data can be stored in cookies ?
Can I store a Dataset in cookie ?
Explain ASP.NET Caching mechanism in detail ?
How can I make ASP.NET to fetch new data as soon as data store has changed ?
What will be the o/p of this code

try
{
Response.Redirect("Page1.aspx");
}
Catch(Exception Ex)
{
}

How can we eliminate the exception in the above code ?
What is auto event wireup ? What is its use ?
What is 'compilation' section in 'web.config' used for ?
What is .pdb files ? What is its use ? What information does it contain ?
What is the 'compilers' section in web.config used for ?
What are page directives ? Name some and their purpose.
How can u access and change a header section in Master page from a content page ? Which event can you use for this ?
What are custom error modes in ASP.NET ?
What is the purpose of "Remote Only" ?
Suppose the application support person sends you a detailed screen shot of the error from production, How will you troubleshoot the issue ?

Thursday, December 17, 2009

K-MUG Session on 19th Saturday at Technopark, Trivandrum





next K-MUG User group session on 19th Saturday. More details can be located under event page of Kerala Microsoft Users Group (K-MUG) web site.