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

Which join is default?

0 Answers  

---

What is the usage of distinct keyword?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

How many aggregate functions are available there in sql?

0 Answers  

---

What is a record in a database?

0 Answers  

---

Differentiate between pl/sql and sql?

0 Answers  

---

how to shutdown mysql server? : Sql dba

0 Answers  

---

Explain select statements in sql?

0 Answers  

---

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

---