1. SAP
2. Seibel
3. Salesforce
4. MS CRM Dynamics
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Tell some popular CRM Tools
Thursday, March 31, 2011
1. SAP
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the expansion of CRM ?
Thursday, March 24, 2011
customer relationship management.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the expansion of DBCC ?
Wednesday, March 23, 2011
Database Console Commands.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the expansion of CTE ?
Common Table Expression.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is a MERGE Statement ?
Tuesday, March 22, 2011
It is a statement which gives a way to perform multiple DML operations.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Filtered Index ?
Monday, March 21, 2011
A Filtered Index is an optimized form of non clustered index. A Filtered Index allows us to create a filter to index a subset of rows within a table.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are Sparse columns ?
They are ordinary columns optimized for storage of null values, thereby reducing storage physical space.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Where are Usernames and Passwords stored in SQL Server ?
Sunday, March 20, 2011
In System Catalog Views sys.server_principals and sys.sql_logins.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you change the server level settings in SQL Server ?
What are the types of Cursors in SQL Server ?
1. Static
2. Keyset-driven
3. Dynamic
4. Fast-Forward only
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you get the last error no in SQL Server ?
How will you get GUID in SQL Server ?
Daily Tips- Tip #85 - SQL Performance Tuning
sp_depends is the stored procedure is used to know which table use a rule or default.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #84 - SQL Performance Tuning
sp_unbindrule is the stored procedure which is used to unbind rule from table.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #83 - SQL Performance Tuning
sp_bindrule is the stored procedure which is used to bind rule to table.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #82 - SQL Performance Tuning
sp_helptext is the stored procedure which gives details about rules and defaults.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #81 - SQL Performance Tuning
sp_helpdb is the stored procedure which gives details about database.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #80 - SQL Performance Tuning
sp_help is the stored procedure which gives table details.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #79 - SQL Performance Tuning
sp_helpconstraint is the stored procedure to view constraints.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Where are the system stored procedures stored in SQL Server ?
In the Master database
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are the different types of System Testing ?
Saturday, March 19, 2011
1. Facility Testing
2. Volume Testing
3. Stress Testing
4. Usability Testing
5. Security Testing
6. Performance Testing
7. Storage Testing
8. Configuration Testing
9. Installability Testing
10. Reliability Testing
11. Recovery Testing
12. Serviceability Testing
13. Documentation Testing
14. Procedure Testing
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is System Testing ?
The process of comparing the software to its original objectives.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Function Testing ?
It is process of finding discrepencies between the program and requirement.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the other name of Unit Testing ?
What is the expansion of BCP ?
What is a table called if it has no Clustered index and Non-Clustered index ?
what is Log Shipping ?
In SQL Server, it is a process of automating the back up of a database and transaction log files on a production server.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the maximum level of recursion allowed in SQL Server ?
Is recursion allowed in Stored Procedures in SQL Server ?
What is SQL Profiler ?
Its an tool which is used to montior activites in SQL Server and also helps in increasing performance.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are the different types of Sub-Query ?
1. Single-row
2. Multiple-row
3. Multiple-column
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the expansion of OLTP ?
OnLine Transation Processing
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are the different types of Collation sensitivity ?
1. Case sensitivity
2. Accent sensitivity
3. Kana sensitivity
4. Width sensitivity
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the default port number on which SQL Server runs on ?
What is an Identity ?
Its an field which automatically generates numeric values.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are the different kinds of User Defined Functions ?
1. Scalar User-Defined Function
2. Inline Table-Value User-Defined Function
3. Multi-statement Table-Value User-Defined Function
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Collation ?
Set of rules which decides how data is sorted and compared.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the difference between 'where' and 'Having' Clause ?
'Where' works before statement is executed and 'having' after executioin. 'Where' is always peferred over 'having'.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is cross page posting?
Friday, March 18, 2011
It is a post back to a different page.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Sliding Expiration ?
When an expiration is set to expire if there is no activity for some time then it is called as Sliding Expiration.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Absolute Expiration ?
When an expiration is set to expire on a specific date and time it is Absolute Expiration.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you get the stack trace in your application ?
System.Environment.StackTrace;
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you stop an Iterator ?
using 'Yield break' statement.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Which property specifies the the command is a Stored Procedure?
Thursday, March 17, 2011
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?
What is the name of the method which is used to get the ProcessId?
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?
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
What is Classic Mode Authentication ?
Wednesday, March 16, 2011
It refers to the integrated windows authentication.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Claims based Authentication ?
Claims based authentication addresses privacy and other compliance concerns by requesting less specific, less personal information about people, and by trusting other parties or systems to do the “proof of identity” check.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are the 2 types of authentication when you create a sharepoint web application?
1. Claims Based Authentication
2. Classic Mode Authentication
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 invoke methods dynamically in Reflection?
Monday, March 14, 2011
System.Type.Invokemember
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the expansion of PKC ?
Public Key Cryptography
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Explain What is a chain of responsibility pattern ?
Sunday, March 13, 2011
The chain-of-responsibility pattern is a design pattern consisting of a source of command objects and a series of processing objects. Each processing object contains a set of logic that describes the types of command objects that it can handle, and how to pass off those that it cannot handle to the next processing object in the chain.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the threading model for ASP.NET ?
MTA Threading model.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is Parallel Computing ?
The .NET Framework 4 introduces a new programming model for writing multithreaded and asynchronous code that greatly simplifies the work of application and library developers. The new model enables developers to write efficient, fine-grained, and scalable parallel code in a natural idiom without having to work directly with threads or the thread pool. The new System.Threading.Tasks namespace and other related types support this new model.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the use of EnableViewStateMac ?
Gets or sets a value indicating whether ASP.NET should check message authentication codes (MAC) in the page's view state when the page is posted back from the client.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
In which event are the controls fully loaded ?
Page_Load Event
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
SQL Server Performance Tuning Techniques - Set 2
11. Use Indexed Columns in where clause columns as they return results faster.
12. Create a primary key on each table you create and unless you are really knowledgeable enough to figure out a better plan, make it the clustered index
13. Create a primary key on each table you create and unless you are really knowledgeable enough to figure out a better plan, make it the clustered index.
14. Create an index on any column that is a foreign key.
15. Use set nocount on at the top of each stored procedure and set nocount off at the bottom.
16. Avoid using temp table unnecessarily, if needed explicity create them.
17. To help identify long running queries, use the SQL Server Profiler Create Trace Wizard to run the "TSQL By Duration" trace.
18. Use Joins instead of Subqueries.
19. "SET NOCOUNT ON" reduces network traffic between server and client.
20. use the SQL Server's Profiler Create Trace Wizard to run the "Profile the Performance of a Stored Procedure" trace to provide you with the data you need to identify poorly performing stored procedures.
21. Use covering index whereever needed, it reduces logical and physical IO and increases performance.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
SQL Server Performance Tuning Techniques - Set 1
1. Use actual column names instead of '*' in the queries.
2. HAVING clause is used to filter the rows after all the rows are selected. It is just like a filter. Do not use HAVING clause for any other purposes.
3. Try to minimize number of subqueries in your query
4. Avoid using IN unnecessarily as IN is slowest.
5. IN is efficient when most of the filter criteria is in the sub-query.
6. EXISTS is efficient when most of the filter criteria is in the main query.
7. Use EXISTS instead of DISTINCT when using joins which involves tables having one-to-many relationship.
8. Try to use UNION ALL in place of UNION.
9. To store large binary objects, first place them in the file system and add the file path in the database.
10. Best practices :
a) Use single case for all SQL verbs
b) Begin all SQL verbs on a new line
c) Separate all words with a single space
d) Right or left aligning verbs within the initial SQL verb
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is Database Mirroring ?
Saturday, March 12, 2011
Mirroring is creating an additional instance of a SQL Server, thereby increasing availability. The source instance is called Principal Server and the target instance is called the Mirrored server.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the work of the DTC ?
The DTC manages the committing of transactions when there are several different data sources involved.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the expansion of DTC ?
Distributed Transaction Coordinator .
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #73 - SQL Performance Tuning
"SET NOCOUNT ON" reduces network traffic between server and client.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #72 - SQL Performance Tuning
use the SQL Server's Profiler Create Trace Wizard to run the "Profile the Performance of a Stored Procedure" trace to provide you with the data you need to identify poorly performing stored procedures..
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is a Linked Server ?
It is an alias on the local SQL Server which points to an external data source.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #71 - SQL Performance Tuning
Use covering index whereever needed, it reduces logical and physical IO and increases performance.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What are Covering Indexes?
A covering index, is a form of a composite index, includes all of the columns referenced in the SELECT, JOIN, and WHERE clauses of a query. It reduces logical and physical IO and increases performance.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #70 - SQL Performance Tuning
Use Joins instead of Subqueries.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is the expansion of SARG ?
Search ARGument.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the advantage of UNION ALL over UNION with respect to performance?
The advantage of the UNION ALL is that is does not perform the SELECT DISTINCT function where the UNION does.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #69 - SQL Performance Tuning
To help identify long running queries, use the SQL Server Profiler Create Trace Wizard to run the "TSQL By Duration" trace.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #68 - SQL Performance Tuning
Avoid using temp table unnecessarily, if needed explicity create them.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #67 - SQL Performance Tuning
Use set nocount on at the top of each stored procedure and set nocount off at the bottom.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #66 - SQL Performance Tuning
Create an index on any column that is a foreign key.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #65 - SQL Performance Tuning
Create a primary key on each table you create and unless you are really knowledgeable enough to figure out a better plan, make it the clustered index.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is a tuple?
A tuple usually represents an object and information about that object.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #64 - SQL Performance Tuning
EXISTS is efficient when most of the filter criteria is in the main query.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #63 - SQL Performance Tuning
Use Indexed Columns in where clause columns as they return results faster.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #62 - SQL Performance Tuning
IN is efficient when most of the filter criteria is in the sub-query.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #61 - SQL Performance Tuning
Avoid using IN unnecessarily as IN is slowest..
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #60 - SQL Performance Tuning
Try to minimize number of subqueries in your query.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #59 - SQL Performance Tuning
Use actual column names instead of '*' in the queries.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the difference between UNION and UNION ALL ?
Friday, March 11, 2011
Union returns distinct values,unionall returns all values.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is WAS Tool?
Web Application Stress ( WAS ) tool, simulates multiple HTTP clients making requests to your Web site, while ASP.NET includes a number of performance counters that you can use to track the execution of your application.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #58 - Better Global.asax
create a custom base class for the Global.asax file. This base class inherits from the HttpApplication class, just like the default Global class that sits behind the Global.asax file. The custom base class provides the same members as the default Global.asax file, but even better, you can extend the class with additional members, such as custom properties for tracking counters.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Name any popular IP Redirector?
Cisco’s LocalDirector or F5 Network’s BIGIP.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Will ACT provide HTTP Errors Count?
What is TCA?
Transaction Cost Analysis (TCA), provides a quantitative measure of the processing cost of your application for a specific user load.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is TTLB?
This counter measures (in milliseconds) how long it takes for the Web application to service a request. TTLB is a key
indicator of how scalable an application is.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the expansion of TTLB?
Time to Last Byte.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is ACT?
Application Center Test (ACT), is a stress test tool for Web applications.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the expansion of ACT ?
Application Center Test
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
How will you start Asp.net State Service?
Start >Programs > Administrative Tools > Services > ASP.NET State Service
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #57 - Background Processing
Use background processing on suitable situations. Use Timer class, found in the System.Threading namespace.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #56 - Connection Pooling
Avoid repeatedly connecting to the database , instead use Connection Pooling.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #55 - Avoid unnecessary Boxing and Unboxing
Use generics collection as compared to simple collection , to avoid boxing / unboxing.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #54 - DB Coding in Application
Use as much of Stored Procedure as you can instead of queries inside the application. By this the execution happens at the backend and only results are returned thereby increasing performance and speed.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #53 - String concatination
Use StringBuilder for string concatination instead of String
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Which one is faster Hashtable or Dictionary?
Dictionary is faster than Hashtable.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What are the most popular naming conventions ?
Pascal , Camel and Hungarian
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What does the Substitution Control does?
The Substitution control specifies a section on an output-cached Web page that is exempt from caching.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Does Post Cache Substitution disables dynamic Caching?
Yes. It dynamically disables public (or client) caching and switches the page to use server caching. This is because the substitutions need to happen via server-side logic.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
How will you implement Post Cache Substitution?
It can be implemented in 2 methods:
1. Call the new Response.WriteSubstitution method, passing it a reference to the desired
substitution method callback.
2. Add a control to the page at the desired location, and set its
methodName attribute to the name of the callback method.
methodName attribute to the name of the callback method.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is Post Cache substitution?
It implements a dynamic region within a cached page.
Ex: In AdRotator entire page will be cached but a new ad will be displayed on every request.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Can we post and access view state in another application?
If you post to other applications, PreviousPage property will be null.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
How can i get all the objects in Cache?
The following statement fetches all the objects in cache and stores in a dictionary object.
IDictionaryEnumerator CacheEnum = HttpContext.Current.Cache.GetEnumerator();
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is Expression Blend?
Microsoft Expression Blend is a user interface design tool from Microsoft for creating graphical interfaces for web and desktop applications.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What are the disadvantages of using Hidden Fields?
1. Not Secure
2. Reduces Performance on huge data
3. Doesnt support complex data
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What are the advantages of using Hidden Fields?
1. Easy to implement.
2. Data is cached at client side hence supports Web Farms
3. Most of the browsers support them
4. Reduces usage of server resources
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What are the Session Modes which support Session_End event?
InProc mode alone has Session_End Event.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
How can we access cache object in ASP.NET ?
You can get the cache object either from Cache property of HttpContext class or Page object.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is the website for istqb related details?
Monday, March 7, 2011
www.istqb.org
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What the various levels in ISTQB certification?
a. Foundation
b. Advanced
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is Selenium?
Saturday, March 5, 2011
It is open source test automation tool widely used.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
What is cross browser Testing?
It is a method of testing an application over multiple browsers and operating systems.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Subscribe to:
Posts (Atom)
LinkWithin
