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 data base testing, explain with example

4 Answers  

write four critical test cases for logout operation?

6 Answers   Mind Tree,

What is security Hole ? Is this possible Some one can acess any of restricted page (like admin side)? How you test this previllaze?

0 Answers   Magic Software, Wipro,

what is the difference between reference key and foreign key

2 Answers   AZTEC,

exact difference between smoke testing, sanity testing and unit testing

2 Answers  

What is Regression Testing?

22 Answers   IBM, Sapient, Siemens,

We believe in ad-hoc software processes for projects. Do you agree with this? Please explain your answer.

2 Answers   Ordain Solutions,

what is verification, validation

9 Answers   iGate,

How do you go about testing a project ?

2 Answers  

What is configuration Management What is change management What are Severity and priority levels What is Data integrity and Data validity What are the browsers available and explain their versions Is it possible that Quality variates project to project What are GUI Map files and explain their Contents What is Data base check point and why we go for that What is the difference between the Client server application and a Web application Does Winrunner Supports Web applications What is process Management What is an Error, Defect, Bug What is Quality Which version of Winrunner you are using What is Build Verification and why we go for it What is Defect density What is Integration testing What is Static testing and types of Static testing What is Validation testing what is Data driven testing and why we go for data driven testing what is the definition of Testing What is Sanitation Testing

1 Answers   Semantic Space,

Password is having 6 digit alphanumeric then what are the possible input conditions?

0 Answers  

What is the diff bet test scenario and test case.

3 Answers