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

When we use Comparison Testing ?

2 Answers   Crea,

---

What is the different cost elements involved in implementing process in an organization?

0 Answers  

---

can u explain about iteration model? And what is it?

2 Answers   iNautix,

---

If a bug has high severity then usually that is treated as high priority,then why do priority given by test engineers/project managers and severity given by testers?

4 Answers   Ordain Solutions,

---

What is benchmark testing? hi friends... can anyone suggest the correct answer plz...

1 Answers  

---

---

How to test URl of a website manualy?

3 Answers   Oracle, Wipro,

---

Difference between Test Plan & Test Strategy?

6 Answers  

---

what are reviews in sdlc?

2 Answers   Semantic Space,

---

Explain v-model clearly ? how it works in real time on a project?

3 Answers   Mphasis,

---

Which type of requirement suitable for water fall model, v model, prototype model, incremental model, agile model, ? plz explain with example....please give the answer immediately

1 Answers  

---

What is the non configurable item in SDLC.

3 Answers   Wipro,

---

tell about build process???how do u get abuild?? what u l do when u get a build??

2 Answers   FIC, IBM,

---