Answer / a.jyothsna

1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join

Answer / desiraju venkata subramanya ka

types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin

Answer / prakash

Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join

Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins

Answer / 123

cross join

Does google use sql?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

If the base table structure is changed what will happen to join index????

2 Answers  

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

what is the different between unique+not null & primary key,

4 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---

What is an inconsistent dependency?

0 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

What is a record in pl/sql?

0 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

How many sectors are in a partition?

0 Answers  

---