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

What is diff between Reliability Testing and Recovery Testing ?

1 Answers  

---

Hi, my name is Maiko and I work as a Business Analyst. Does anybody have experience with TOSCA Testsuite? I hear it's all new and great but I can't really find any user reviews. Please help me out. thx

2 Answers  

---

what is the difference between stress and load testing

6 Answers  

---

what is cvs in testing

2 Answers   iSoft,

---

What all types of testing you will do for banking website?

0 Answers   HCL,

---

test cases for internet explorer

2 Answers   College School Exams Tests, Wipro,

---

Hi, I am new to testing.where we will use SQL in manual testing. To what extent i need to learn SQl.there are diff types of SQL like TSql,Mysql etc.i little bit confused,help me. Thank you .

4 Answers  

---

what is deferred in defect life cycle

10 Answers   Accenture,

---

Suppose,u have written 10 test cases for an application,but ur developer is not satisfied wht u wrote,then how will u justify him that ur test cases are correct?

2 Answers   CFC,

---

tell me about detailed process of bug tracking in your company?questions was asked in interveiw?

4 Answers   TCS,

---

while reading specification documents if u got any doubts or u think the specification should be clear or when u think some changes should be there in specifcation docs, or u find the difference in FRS and Design docs,whom do u report this??

4 Answers   AOL,

---

What is fuzz testing?

0 Answers  

---