Answer / swaroopa

What is Equi Join and Outer Join ?

Equi Joins are also called Simple Joins or Inner Joins.
An equi-join is a join based on equality or matching
between the column values for two different tables.

This equality is indicated with an equal sign (=) as the
comparison operator in the WHERE clause

Ex:SELECT * FROM manufact, stock
WHERE manufact.manu_code = stock.manu_code

manufact and stock are the tables on the manu_code column.
It retrieves only those rows for which the values of the
two columns are equal.

Outer Join:

OUTER JOIN is used to join two tables even if there is not
a match. The joined table retains each record—even if no
other matching record exists. Outer joins subdivide further
into left outer joins, right outer joins, and full outer
joins, depending on which table(s) one retains the rows
from (left, right, or both).

Answer / latha

self join:one physical table is divided into two logical tables and perform join operation on that tables.
query:
select a.eno,a.ename,b.ename as manager name from emp a,emp b where a.manager num=b.eno
equi join:perform join operations on matching columns on both the tables

 You are New to the city,You don't have any Gadgets,you have   only address on paper piece.You are almost nearer to your destination, You have asked one man and he replied saying "Go straight and take Right(Dead End)".After moving some distance you have asked another person and he replied saying "Go straight and take Left (Dead End).And finally question here is As a tester which path you can choose and why? 

5 Answers   Bally Technologies, SSS,

---

wht is the diff b/w funtional testing and integration testing

4 Answers  

---

In V model how will you explain all testing types (unit,integration,sysetem,acceptance testing) as all these parallel testing.E.g.Once the design phase is completed how will you do the integration teting over here as tester doesnt know much about design.Briefly justify the V-model?

1 Answers   Mind Tree,

---

those who want to gain real time experience feel free to contact me

1 Answers  

---

What are the Test Cases for a login in to your email which has username and password?

1 Answers  

---

Advantages and Disadvantages of different SDLC models?

8 Answers   Harvard, IBM, Midas Technologies,

---

are there any difference Between Error,Bug,Issue ? (defination wise)..

3 Answers  

---

Explain me software life cycle and SDLC

3 Answers  

---

what is test case and test scenario , plz do explan with example....

1 Answers  

---

Explain about Security Testing in webbased application?

2 Answers   Crea,

---

I need information on sales domain?need modules information for online shopping projects for project.

0 Answers  

---

A Succesful testcase Means..?

14 Answers   HCL,

---