DOT NET

Ans: A fundamental rule in three-tier architecture is the client tier never communicates directly with the data tier; in a three-tier model all communication must pass through the middleware tier.

It’s liner architecture. This addresses the question of how to pass information between a user and a database. Where as MVC is a triangular architecture: the View sends updates to the Controller, the Controller updates the Model, and the View gets updated directly from the Model. This addresses questions of how a user interface manages the components on the screen.

Presentation layer(aspx, aspx.cs) = view and controller MVC (aspx, aspx.cs)
Application Layer = Model of MVC
Database layer = DB layer of MVC

Advantages of using MVC in ASP.NET

There's no duplicated code.
The business logic is encapsulated; hence the controller code is transparent and safer.
The business logic can be used in several front ends like Web pages, Web services, Windows applications, services, etc.
Exception handling is well managed showing the user only digested error messages.
Testing every part of an application is easier as it can be done separately using automated methods.
Application changes are easier to apply as they are focused in one part of the architecture only.

Thursday, November 4, 2010

Team Foundation Server for QA professionals

1) http://www.objectsharp.com/training/courses/Pages/Team-Foundation-Server-2010-for-QA-Professionals.aspx
2) http://www.mytechfinds.com/articles/software-testing/7-manual-testing
3)

Wednesday, November 3, 2010

C# Interview Questions

1) http://dev.fyicenter.com/Interview-Questions/C-sharp/
2) http://www.careerride.com/CSharp-Interview-Questions.aspx (best site)
3) http://c-sharp-interviewquestions.blogspot.com/
4) http://faq.programmerworld.net/programming/csharp-interview-questions-answers.html (Basic interview questions)
5) http://www.aired.in/2009/11/c-sharp-interview-questions-answers.html (real time interview questions)

Tuesday, November 2, 2010

VisualStudioTeam System

1) http://letmeget.com/blog/microsoft-tfs-2010-microsoft-visual-studio-team-foundation-server-2010
2) http://www.microsoft.com/visualstudio/en-us/products/2010-editions/team-foundation-server/features
3) http://www.dotnetcurry.com/ShowArticle.aspx?ID=195
4) http://www.clemensreijnen.nl/post/2009/02/13/Visual-Studio-Team-System-2010-e28093-Episode-3-The-Lifecycle.aspx
5) http://dennisv.net/2009/01/14/test-driven-development-tdd-in-vsts-2010/

TFS

1) http://blogs.msdn.com/b/bharry/archive/2009/04/30/tfs-2010-admin-operations-setup-improvements.aspx

2) http://code.msdn.microsoft.com/TfsSdk (SDK)
3) http://blogs.msdn.com/b/bharry/archive/2009/04/19/team-foundation-server-2010-key-concepts.aspx
4) http://channel9.msdn.com/Blogs/pdc2008/TL52 Video
5) what is Team foundation server and Work Item tracking experience?
Ans: it's a microsoft product. The server-side component is team foundation server (commonly abbreviated tfs), which comprises two components: the application tier and the data tier. The application tier is a set of web services that provide access to tfs functionality, and a web portal and document repository facilitated by windows sharepoint services, whereas the data tier is essentially a microsoft sql server 2005 standard installation that warehouses all the information for tfs. Both tiers are required, but can be installed on the same or separate servers. Team foundation server contains one or more team projects, which consists of visual studio solutions, configuration files for team build and team load test agents, and a single sharepoint repository containing the pertinent documents for the project. It can be used as bug tracking tool, we can write test cases using tfs, we can publish the results of test cases in it, and we can use it as a source control repository.
6) http://bisherryli.wordpress.com/category/team-foundation-server-tfs/
7) http://blogs.msdn.com/b/jasonz/archive/2009/10/21/tutorial-getting-started-with-tfs-in-vs2010.aspx
8) http://blogs.msdn.com/b/aaronbjork/archive/2009/10/26/how-does-msf-agile-4-2-compare-to-msf-agile-5-0.aspx

Wednesday, October 27, 2010

Oracle

http://dbis.ucdavis.edu/courses/sqltutorial/tutorial.pdf

Sunday, October 24, 2010

OOP's Concept in Java

1) http://download.oracle.com/javase/tutorial/java/concepts/
2) http://www.java-questions.com/oops_interview_questions.html
3) http://www.exforsys.com/tutorials/oops.html
4) http://www.codeproject.com/KB/architecture/OOP_Concepts_and_manymore.aspx (Best One to refer)

SQL Queries Eamples

1) http://www.sql-tutorial.com/sql-aggregate-functions-sql-tutorial/
2) http://www.w3schools.com/sql/sql_orderby.asp
3) http://www.1keydata.com/sql/sqlorderby.html
4) http://www.webcheatsheet.com/SQL/interactive_sql_tutorial/sql_orderby.php
5) http://www.techonthenet.com/sql/order_by.php
6) http://85.25.126.90/wiki/SQL_FAQ
7) http://www.java2s.com/Code/Oracle/CatalogOracle.htm
8) http://sqlzoo.net/

Tuesday, October 19, 2010

.Net Interview Questions- 19Oct2010 - 7:00PM EST

The below questions are the phone screening questions before applying to the client.

1) What is abstract class

2) Inheritance

3) Difference between Interface and inheritance

4) Access specifiers private, protected, Public.

5) Try catch loop

6) Does try catch loop can contain multiple catch blocks

7) Try catch Finally

8) What are stored procedures

9) Joins (inner,outer, equi join, left outer join )

10) Difference between select stmt and stored procedure

Ans:

When I first started using SQL Server as a novice, I was initially confused as to the differences between the SELECT statement, views, and stored procedures. They all seemed to perform more or less the same task (retrieve data), and I wanted to know the pros and cons of using each.
Why would SQL Server offer three different options to retrieve data from database? As a developer and new DBA, I took it upon myself to learn everything I could about these options, why they may be required, and when they should be used. This article is a result of my learning and experience, and explains the differences between SELECT statements, views, and stored procedures for the DBA or developer new to SQL Server. I hope you find this article useful.
As you read this article, if you choose, you can cut and paste the code into Query Analyzer I have provided in order to more fully understand and appreciate the differences between the SELECT statement, views, and stored procedures. I have divided this article into three parts to better explain this information.

Starting Notes
To get us started on learning the differences between the SELECT statement, views, and stored procedures, I need to mention the syscacheobjects system table. It is used to store information about compiled objects and their execution plans. The reason for this is because compiled SELECT statements, views, and stored procedures are stored here, and I have used this table to experiment and learn more about how these three different objects are stored and used by SQL Server. If you are not familiar with this system table, you might want to take a peek at it. It is stored in the master database, and can be viewed with Enterprise Manager or Query Analyzer.
If you choose to follow along with the examples in this article, you will want to run the DBCC FREEPROCCACHE command before each run. This command clears the syscacheobjects table of any current cached objects, and allows us to perform more accurate tests.
Now, let’s create a table and input a few rows in the table before we commence at taking a look at the differences between the SELECT statement, views, and stored procedures.

Create Sample Table
I assume you have a database you can use for this. If not, you will want to create one at this time. Now, we need to create a table for our experimentation.
Create Table DummyTable1
(
EmpId Int,
EmpName Varchar(8000)
)
Now, let’s add a few records in this table using this script:

Insert Into DummyTable1 Values (1, Replicate ('a',20))
GO
Insert Into DummyTable1 Values (2, Replicate ('b',20))
GO
Insert Into DummyTable1 Values (3, Replicate ('c',20))
GO
Insert Into DummyTable1 Values (4, Replicate ('d',20))
GO
Insert Into DummyTable1 Values (5, Replicate ('e',20))
GO
Insert Into DummyTable1 Values (6, Replicate ('f',20))
GO
Insert Into DummyTable1 Values (7, Replicate ('g',20))
GO
Insert Into DummyTable1 Values (8, Replicate ('h',20))
GO
Insert Into DummyTable1 Values (9, Replicate ('i',20))
GO
Insert Into DummyTable1 Values (10, Replicate ('j',20))
GO

DummyTable1 has contains sufficient rows to experiment with the differences between the SELECT statement, views, and stored procedures.
Let us begin with the SELECT statement and see how it is different from views and stored procedures.

SELECT Statement
Now, let’s view the contents of the table by EXECuting the following command in Query Analyzer for our new table.
SELECT EmpId, EmpName FROM DummyTable1
GO

EmpID	EmpName
1	aaaaaaaaaaaaaaaaaaaa
2	bbbbbbbbbbbbbbbbbbbb
3	cccccccccccccccccccc
4	dddddddddddddddddddd
5	eeeeeeeeeeeeeeeeeeee
6	ffffffffffffffffffff
7	gggggggggggggggggggg
8	hhhhhhhhhhhhhhhhhhhh
9	iiiiiiiiiiiiiiiiiiii
10	jjjjjjjjjjjjjjjjjjjj

As you would expect, the data we inserted earlier has been displayed.
Now, let’s execute the following commands to clear the cache.
DBCC FREEPROCCACHE
GO
Freeing the procedure cache prevents an ad-hoc SQL statement from being reused, assuming that it is currently in the cache. This means that the next time we run the same ad-hoc statement, that it must be newly recompiled.

11) Difference between truncate and delete table

Ans: The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.
TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.
From Oracle 10g a table can be "undropped". Example:
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Flashback complete.

12) types of triggers

Ans: Before Trigger, After Trigger, before Insert Trigger, After Insert Trigger, Before Update Trigger and After Update trigger.
http://en.wikipedia.org/wiki/Database_trigger
http://www.sqlteam.com/article/an-introduction-to-triggers-part-i
http://www.aspfree.com/c/a/MS-SQL-Server/Brief-Introduction-to-Triggers-in-SQL-Server-2000/

13) Primary Key, Foreign Key