Answer / uday kumar. a

Two types of joins
1. Inner Join
2. Outer Join
2.a Left outer join
2.b Right outer join

Answer / rajesh v.g.

In SQL Server, we have the following joins
1.Self Join
2.Inner Join
3.Cross Join
4.Outer Join
4.1 Left Outer Join
4.2 Right Outer Join
4.3 Full Outer Join

Answer / shankar

2 types:
1. Inner Join
2. Outer Join
3. Cross Join
1. Inner Join: Inner Join displays matched rows.
2. Outer Join: Outer Join displays matched rows as well as
unmatched rows. Outer Joins again classifed into 3 types.
2a. Left Outer Join: Matched rows as well as left table
unmatched rows.
2b. Right Outer Join: Matched rows as well as right table
unmatched rows.
2c. Full Outer Join: Matched rows as well as left table
unmatched rows and right table unmatched rows.
3. Cross Join: It will display the cartegion product of the
tables.

Answer / suneel reddy

Inner Join
Outer join
self join
cross join

Answer / rk_(processmap)

1)Inner join A join that displays only the rows that have
a match in both joined tables
2)Outer join A join that includes rows even if they do
not have related rows in the joined table
i) Left outer join All rows from the first-named
table
ii) Right outer join All rows in the second-named
table
iii) Full outer join All rows in all joined
tables are included
3)Cross join A join whose result set includes one row for
each possible pairing of rows from the two tables

http://msdn2.microsoft.com/en-us/library/zt8wzxy4
(VS.80).aspx

Answer / giribabu

1)Simple Join
a)Equi join
b)Non Equi-join
2)Self join

3)Outer Join

Answer / smiley

1)Inner Join
- Natural Join
- Cross Join
2)Outer Join
- LEFT Outer Join
- RIGHT Outer Join
- FULL Outer Join
3)Merge Join
4)Hash Join
5)Sort-Merger Join

Answer / hema

equi join
non equi join
left outer join
right outer join

that's it ok......

Answer / knight rider

Types of Joins are:
1.Inner/Simple joins:a)Equi join b)Non-Equi join c)Self join
2.Outer join:a)Left outer join b)Right outer join c)Full
outer join
3.cross join or cartesian product join
4.Natural join

Answer / guest

1. Cartesian Join(product join)
2. Inner Join(Equi join)
3. Outer Join
3.1 Left Outer Join
3.2 Right Outer Join
3.3. Full Join
4. Self Join

What is agile testing ? how can we perform agile testing ?

0 Answers  

What is the general testing process?

6 Answers   Polaris,

There are 20 resources out of which 12 are manual testers, 5 automation testers and 3 performance testers. There are a bunch of projects to be tested in the organisation, the projects belong to various technologies, say 20% of projects in Java, 20% of projects in SAP, 30% of projects in .NET, 30% of projects in C# What is your approach as Test Manager in testing.

0 Answers  

I want the correct answer for this question, because i read so many answers from this site which have wrong answers for this question and so during interviews i only gave wrong answers. If anyone really knows the right answers only then answer, Pls give the examples for: High Priority High severity, HP LS, HS LP, LS LP.

2 Answers  

What is Black Phase in SDLC?

2 Answers  

what is test objective?

19 Answers   CTS, Polaris, Value Labs,

What if the client finds a defect after delivering the product? How will you react and justify?

2 Answers   HeadStrong, IBM, Somany Ceramics,

What is the difference between version and build.

6 Answers   AppLabs, CTS, Seed Infotech,

How can we test for drastic (severe) memory leakages?

0 Answers  

what is the difference between quality assurence and quality control

4 Answers   SunGard,

What is the first test in software testing process?

0 Answers  

What do u mean by Top down approach and Bottom up approach? How will u implement these in u r project ?

7 Answers