Answer / dhivya

Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join

Answer / kavita

Join are used to link then retrive data from same or
different database(both have atleast one common attribute).

Join are basically of two types:
1)Equi Join
2) Non equi join

Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.

b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.

2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables

Which data type cannot be used as a parameter in a udf?

0 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

How to replace not in with not exist?

0 Answers  

---

What are the 18 schemas?

0 Answers  

---

What is dbms explain in brief?

0 Answers  

---

Explain about network model?

0 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

Explain about the storage and physical database design?

0 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

Given an employee table, how would you find out the second highest salary?

9 Answers  

---