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

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

0 Answers  

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

How can I detect whether a given connection is blocked?

0 Answers  

---

Explain about network model?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

Explain about the hierarchical model of the database?

0 Answers  

---

What are the key features of dbms?

0 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---