Which property specifies the the command is a Stored Procedure?

Dim cmld as SqlCommand = conn.CreateCommand()
CommandType = CommandType.StoredProcedure

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 3 values of the ParameterDirection Property?

1. Input
2. Output
3. InputOutput
4. ReturnValue

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Which property tells whether the Parameter is input or output?

ParameterDirection

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the name of the method which is used to get the ProcessId?

GetCurrentProcessId

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Which class provides alternate programmatic approach to Windows Performance Monitor tool?

Systems.Diagnostics.PerformanceCounter

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 2 protected configuration providers in .NET Framework ?

a. RsaProtectedConfigurationProvider
b. DataProtectionCOnfigurationProvider

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the name of class using which you retrieve values from web.config?

WebConfiguration

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the methods using which we can clear Connection Pools?

a. ClearPool
b. ClearAllPools

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #78 - Performance Tuning .NET - How will you assure an objects disposal on all situations ?

With the help of the 'using' statement.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #77 - Performance Tuning .NET - How will you return multiple values from a method ?

By Using the Out keyword on return parameters.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #76 - Performance Tuning .NET - Providing Sorting routines to your class

Implement IComparable in your class, which provides sorting routines of List and SortedList.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #75 - Performance Tuning .NET

Use System.Collections.Generic.Stack and System.Collections.Generic.Queue instead of System.Collections.Stack and System.Collections.Queue

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #74 - Performance Tuning .NET

Use System.Collections.Generic.List instead of System.Collections.ArrayList

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning