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

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

---

What are the main phases of database development?

0 Answers  

---

What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,

---

Explain about query and reporting.

0 Answers  

---

Write the fastest query to find out how many rows exist in a table?

0 Answers  

---

What is database design and development?

0 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---

Explain the family trees and connection by clause.

1 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  

---

Can you have a nested transaction?

1 Answers  

---